How do I select ranges

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do i select ranges in a query

eg. I want to select between 51 and 521 record with addtional info being used to narrow search further.
I want to use the range function or boolean operators but they want work as i am used to excel.

Please help thanks
 
Access is not Excel, "range" does not mean what it does in Excel... You want
to select "records between 51 and 521" as in rows 51 to 521 in Excel? This
is very risky, records from tables will not necessarily come in the order
you expect them!
I strongly suggest you base your selection criteria on field values, not on
record positions!

HTH,
Nikos
 
In the Criteria row of your query, under the appropriate field, enter:
Between 51 And 521

Then add other criteria under the other fields.
 
Access is Row oriented, so everything you do is based upon the selection(or
exclusion) of a row.

If you want to return all of the ID's that are between 51 and 521, then you
will create a query like the following:

Select * from MyTable where ID Between 51 and 521.


--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 
Back
Top