Dsy Network>  www | forum | my | didattica | howto | wiki | el goog | stats | blog | dona | rappresentanti
Homepage
 Register   Calendar   Members  Faq   Search  Logout 
.dsy:it. : Powered by vBulletin version 2.3.1 .dsy:it. > Community > Forum De Bell Tolls > [MS ACCESS] Query Thread Rating: 1 votes, 5.00 average.
Pages (2): [1] 2 »   Last Thread   Next Thread
Author
Thread    Expand all | Contract all    Post New Thread    Post A Reply
Collapse
0m4r
.grande:maestro.

User info:
Registered: Mar 2002
Posts: 7287 (0.85 al dì)
Location: Düsseldorf (DE)
Corso:
Anno: ESAMI FINITI
Time Online: 49 Days, 0:42:50 [...]
Status: Offline

Post actions:

Edit | Report | IP: Logged
 [MS ACCESS] Query

come si fa utilizzando MS ACCESS a realizzare una query in modo tale che mi siano ritornati solo i record compresi in un certo intervallo?
cioè, se a me interessano solo i record dal 5 al 10 come faccio a fare uan query che me li restituisca?

__________________
http://www.twitter.com/0m4r
16-08-2003 16:26
Click Here to See the Profile for 0m4r Click Here to See the Blog of 0m4r Click here to Send 0m4r a Private Message Find more posts by 0m4r Add 0m4r to your buddy list Printer Friendly version Email this Article to a friend Reply w/Quote
Collapse
fozzy
apprentice monk

User info:
Registered: May 2002
Posts: 1968 (0.23 al dì)
Location: Bollate (MI)
Corso: SA-299
Anno: primo...di studio "serio"
Time Online: 10 Days, 10:57:44 [...]
Status: Offline

Post actions:

Edit | Report | IP: Logged

hai un campo ID?

select * from tabella
where ID
between 5 AND 10;

dovrebbe essere piú o meno standard... o no? al limnite usa il wizard questa non dovrebbe avere problemi a crearla..

__________________
I sense much NT in you, NT leads to Blue Screens,
Blue Screens lead to downtime, downtime leads to suffering.

NT is the path to the Dark Side....
16-08-2003 17:47
Click Here to See the Profile for fozzy Click here to Send fozzy a Private Message Visit fozzy's homepage! Find more posts by fozzy Add fozzy to your buddy list Printer Friendly version Email this Article to a friend Reply w/Quote
Collapse
0m4r
.grande:maestro.

User info:
Registered: Mar 2002
Posts: 7287 (0.85 al dì)
Location: Düsseldorf (DE)
Corso:
Anno: ESAMI FINITI
Time Online: 49 Days, 0:42:50 [...]
Status: Offline

Post actions:

Edit | Report | IP: Logged

beetween eccolo, non me lo ricordavo piu...ora provo e ti dico.
comq al solito: grazie!

__________________
http://www.twitter.com/0m4r
16-08-2003 18:16
Click Here to See the Profile for 0m4r Click Here to See the Blog of 0m4r Click here to Send 0m4r a Private Message Find more posts by 0m4r Add 0m4r to your buddy list Printer Friendly version Email this Article to a friend Reply w/Quote
Collapse
fozzy
apprentice monk

User info:
Registered: May 2002
Posts: 1968 (0.23 al dì)
Location: Bollate (MI)
Corso: SA-299
Anno: primo...di studio "serio"
Time Online: 10 Days, 10:57:44 [...]
Status: Offline

Post actions:

Edit | Report | IP: Logged

beh intanto potevi risolvere (in maniera non proprio pulita) con un

where ((x<10) AND (x>5))

:)

incredibile.. ho capito qualcosa di basi di dati??? :lol:

__________________
I sense much NT in you, NT leads to Blue Screens,
Blue Screens lead to downtime, downtime leads to suffering.

NT is the path to the Dark Side....
16-08-2003 18:48
Click Here to See the Profile for fozzy Click here to Send fozzy a Private Message Visit fozzy's homepage! Find more posts by fozzy Add fozzy to your buddy list Printer Friendly version Email this Article to a friend Reply w/Quote
Collapse
Lunik
dsy core staff

User info:
Registered: Mar 2002
Posts: 22362 (2.62 al dì)
Location: Milano
Corso: ComDig
Anno: Dott.ssa
Time Online: 93 Days, 0:52:10 [...]
Status: Offline

Post actions:

Edit | Report | IP: Logged

Off-Topic:
e meno male ke avevi dato gestione dell'informazione!!

__________________
Il DSY su Facebook!!!
16-08-2003 19:04
Click Here to See the Profile for Lunik Click Here to See the Blog of Lunik Click here to Send Lunik a Private Message Visit Lunik's homepage! Find more posts by Lunik Add Lunik to your buddy list Printer Friendly version Email this Article to a friend Reply w/Quote
Collapse
0m4r
.grande:maestro.

User info:
Registered: Mar 2002
Posts: 7287 (0.85 al dì)
Location: Düsseldorf (DE)
Corso:
Anno: ESAMI FINITI
Time Online: 49 Days, 0:42:50 [...]
Status: Offline

Post actions:

Edit | Report | IP: Logged

Originally posted by fozzy
beh intanto potevi risolvere (in maniera non proprio pulita) con un

where ((x<10) AND (x>5))

:)

incredibile.. ho capito qualcosa di basi di dati??? :lol:


e quell' x cosa sarebbe?

__________________
http://www.twitter.com/0m4r
16-08-2003 19:41
Click Here to See the Profile for 0m4r Click Here to See the Blog of 0m4r Click here to Send 0m4r a Private Message Find more posts by 0m4r Add 0m4r to your buddy list Printer Friendly version Email this Article to a friend Reply w/Quote
Collapse
fozzy
apprentice monk

User info:
Registered: May 2002
Posts: 1968 (0.23 al dì)
Location: Bollate (MI)
Corso: SA-299
Anno: primo...di studio "serio"
Time Online: 10 Days, 10:57:44 [...]
Status: Offline

Post actions:

Edit | Report | IP: Logged

l'ID... non mi veniva in mente ed ho messo quello :D

__________________
I sense much NT in you, NT leads to Blue Screens,
Blue Screens lead to downtime, downtime leads to suffering.

NT is the path to the Dark Side....
16-08-2003 20:38
Click Here to See the Profile for fozzy Click here to Send fozzy a Private Message Visit fozzy's homepage! Find more posts by fozzy Add fozzy to your buddy list Printer Friendly version Email this Article to a friend Reply w/Quote
Collapse
0m4r
.grande:maestro.

User info:
Registered: Mar 2002
Posts: 7287 (0.85 al dì)
Location: Düsseldorf (DE)
Corso:
Anno: ESAMI FINITI
Time Online: 49 Days, 0:42:50 [...]
Status: Offline

Post actions:

Edit | Report | IP: Logged

non mi va bene l'ID perche se io nella tabella cancello dei record poi non ne ho piu 5 ritornati dalla query ma magari solo 4 perche uno l'ho cancellato...

__________________
http://www.twitter.com/0m4r
17-08-2003 09:58
Click Here to See the Profile for 0m4r Click Here to See the Blog of 0m4r Click here to Send 0m4r a Private Message Find more posts by 0m4r Add 0m4r to your buddy list Printer Friendly version Email this Article to a friend Reply w/Quote
Collapse
fozzy
apprentice monk

User info:
Registered: May 2002
Posts: 1968 (0.23 al dì)
Location: Bollate (MI)
Corso: SA-299
Anno: primo...di studio "serio"
Time Online: 10 Days, 10:57:44 [...]
Status: Offline

Post actions:

Edit | Report | IP: Logged

ma usando between hai lo stesso problema...

__________________
I sense much NT in you, NT leads to Blue Screens,
Blue Screens lead to downtime, downtime leads to suffering.

NT is the path to the Dark Side....
17-08-2003 18:14
Click Here to See the Profile for fozzy Click here to Send fozzy a Private Message Visit fozzy's homepage! Find more posts by fozzy Add fozzy to your buddy list Printer Friendly version Email this Article to a friend Reply w/Quote
Collapse
0m4r
.grande:maestro.

User info:
Registered: Mar 2002
Posts: 7287 (0.85 al dì)
Location: Düsseldorf (DE)
Corso:
Anno: ESAMI FINITI
Time Online: 49 Days, 0:42:50 [...]
Status: Offline

Post actions:

Edit | Report | IP: Logged

perche questa insert da l'errore riportato nell'immagine? E sopratutto cosa cavolo significa l'errore?

code:

INSERT INTO SistemaSocieta VALUES ((SELECT LAST(ID) FROM SistemaPartenza), 4)


__________________
http://www.twitter.com/0m4r
18-08-2003 09:54
Click Here to See the Profile for 0m4r Click Here to See the Blog of 0m4r Click here to Send 0m4r a Private Message Find more posts by 0m4r Add 0m4r to your buddy list Printer Friendly version Email this Article to a friend Reply w/Quote
Collapse
kokorina
.:video:girl:.

User info:
Registered: Nov 2002
Posts: 1821 (0.22 al dì)
Location: Milano
Corso: Comunicazione Digitale
Anno: 3°fc più o meno
Time Online: 40 Days, 23:49:06: [...]
Status: Offline

Post actions:

Edit | Report | IP: Logged

Originally posted by 0m4r
non mi va bene l'ID perche se io nella tabella cancello dei record poi non ne ho piu 5 ritornati dalla query ma magari solo 4 perche uno l'ho cancellato...


se usi l'ID con formato contatore si, ma se lo usi come formato testo no

__________________
ogni mattina in africa quando sorge il sole una gazzella muore, cioè si sveglia ed è già morta perchè non stava tanto bene il giorno prima
in africa ogni mattina quando sorge il sole un leone si sveglia, appena sveglio inizia a correre per non fare la fine della gazzella non importa se sei crotalo o pavone, l'importante è che se muori me lo dici prima
"il tu che conosci è l'io che sono"
in RINO veritas
19-08-2003 16:28
Click Here to See the Profile for kokorina Click Here to See the Blog of kokorina Click here to Send kokorina a Private Message Find more posts by kokorina Add kokorina to your buddy list Printer Friendly version Email this Article to a friend Reply w/Quote
Collapse
fozzy
apprentice monk

User info:
Registered: May 2002
Posts: 1968 (0.23 al dì)
Location: Bollate (MI)
Corso: SA-299
Anno: primo...di studio "serio"
Time Online: 10 Days, 10:57:44 [...]
Status: Offline

Post actions:

Edit | Report | IP: Logged

sbattone pazzesco gestire poi correttmaente l'ordinamento.. Quando cancelli devi cambiare il numero a tutti i successivi...
meglio inventarsi qualcosa di diverso....
ma pure te 0m4r... usare PHP no? :D

__________________
I sense much NT in you, NT leads to Blue Screens,
Blue Screens lead to downtime, downtime leads to suffering.

NT is the path to the Dark Side....
19-08-2003 18:08
Click Here to See the Profile for fozzy Click here to Send fozzy a Private Message Visit fozzy's homepage! Find more posts by fozzy Add fozzy to your buddy list Printer Friendly version Email this Article to a friend Reply w/Quote
Collapse
0m4r
.grande:maestro.

User info:
Registered: Mar 2002
Posts: 7287 (0.85 al dì)
Location: Düsseldorf (DE)
Corso:
Anno: ESAMI FINITI
Time Online: 49 Days, 0:42:50 [...]
Status: Offline

Post actions:

Edit | Report | IP: Logged

Originally posted by fozzy
ma pure te 0m4r... usare PHP no? :D


io uso java che è meglio...

__________________
http://www.twitter.com/0m4r
19-08-2003 19:09
Click Here to See the Profile for 0m4r Click Here to See the Blog of 0m4r Click here to Send 0m4r a Private Message Find more posts by 0m4r Add 0m4r to your buddy list Printer Friendly version Email this Article to a friend Reply w/Quote
Collapse
fozzy
apprentice monk

User info:
Registered: May 2002
Posts: 1968 (0.23 al dì)
Location: Bollate (MI)
Corso: SA-299
Anno: primo...di studio "serio"
Time Online: 10 Days, 10:57:44 [...]
Status: Offline

Post actions:

Edit | Report | IP: Logged

e allora trovati le funzioni di accesso al DB, ordina per ID e salta direttamente alla riga che ti interessa...

:ciaociao:

__________________
I sense much NT in you, NT leads to Blue Screens,
Blue Screens lead to downtime, downtime leads to suffering.

NT is the path to the Dark Side....
19-08-2003 19:42
Click Here to See the Profile for fozzy Click here to Send fozzy a Private Message Visit fozzy's homepage! Find more posts by fozzy Add fozzy to your buddy list Printer Friendly version Email this Article to a friend Reply w/Quote
Collapse
0m4r
.grande:maestro.

User info:
Registered: Mar 2002
Posts: 7287 (0.85 al dì)
Location: Düsseldorf (DE)
Corso:
Anno: ESAMI FINITI
Time Online: 49 Days, 0:42:50 [...]
Status: Offline

Post actions:

Edit | Report | IP: Logged

con access non si puo, almeno, io non ci sono riuscito...

__________________
http://www.twitter.com/0m4r
19-08-2003 19:49
Click Here to See the Profile for 0m4r Click Here to See the Blog of 0m4r Click here to Send 0m4r a Private Message Find more posts by 0m4r Add 0m4r to your buddy list Printer Friendly version Email this Article to a friend Reply w/Quote
All times are GMT. The time now is 21:08.    Post New Thread    Post A Reply
Pages (2): [1] 2 »   Last Thread   Next Thread
Show Printable Version | Email this Page | Subscribe to this Thread | Add to Bookmarks

Forum Jump:
Rate This Thread:

Forum Rules:
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts 		HTML code is OFF
vB code is ON
Smilies are ON
[IMG] code is ON
 

Powered by: vBulletin v2.3.1 - Copyright ©2000 - 2002, Jelsoft Enterprises Limited
Mantained by dsy crew (email) | Collabora con noi | Segnalaci un bug | Archive | Regolamento | Licenze | Thanks | Syndacate
Pagina generata in 0.082 seconds (69.83% PHP - 30.17% MySQL) con 22 query.