ACCESS FEED: RE: [MS_AccessPros] How do I get a range of numbers in a query?

Rabu, 28 Agustus 2013

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