This can be done with a between
Try
Between 26 and 75
on the criteria line
Jim Wagner
________________________________
________________________________
From: mahinalanibaker <mahinalanibaker@yahoo.com>
To: MS_Access_Professionals@yahoogroups.com
Sent: Wednesday, August 28, 2013 10:00 AM
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.
[Non-text portions of this message have been removed]
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (2) |
Tidak ada komentar:
Posting Komentar