Note that Between will *include* the values 26 and 75. If you really want
>26, < 75, do:
>26 AND <75
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)
-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of John Viescas
Sent: Wednesday, August 28, 2013 7:08 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: RE: [MS_AccessPros] How do I get a range of numbers in a query?
Try:
Between 26 And 75
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)
-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of
mahinalanibaker
Sent: Wednesday, August 28, 2013 7:00 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] How do I get a range of numbers in a query?
Again, I'm a new user running Access 2007. I have been reading access basics
docs, watching all the youtube videos I can, but I just don't know what I'm
doing wrong. I am having the hardest time asking the query what I need. I'm
beginning to think it can't do it. I need to get a range of numbers. My
first query I needed info that was <25 which came out perfect. Now I need
the info for 26-75. I tried putting >26,<75 and that didn't work said I
couldnt use a comma. So when I put in >26<75 it added everything. Can anyone
plese point me out to what I'm doing wrong?
Thanks again for all then help.
------------------------------------
Yahoo! Groups Links
------------------------------------
Yahoo! Groups Links
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (5) |
Tidak ada komentar:
Posting Komentar