Formula for quering a range of numbers

  • Thread starter Thread starter NervousFred
  • Start date Start date
N

NervousFred

I have a database that has a field of numbers in it used to identify
aircraft. From this I only need a certain set of aircraft. The aircraft are
in the number range 10865-11143. I am trying to figure out if there is a
formula operator to put inbetween the two numbers in the query that will let
access know to just pull back only that range of numbers. As of right now I
can only pull back one single number or the entire database of numbers.

Any Suggestions?

Thanks!
 
BETWEEN 10865 AND 11143


as criteria, under the aircraft "number", in the query designer.


Vanderghast, Access MVP
 
Worked like a charm. Thanks for the response!

Michel Walsh said:
BETWEEN 10865 AND 11143


as criteria, under the aircraft "number", in the query designer.


Vanderghast, Access MVP
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add/Subtract columns from tab to tab in same file 3
at a loss 17
UK Drone Registration 7
how to solve the following in excel 1
UPS Aeroplane Gripe sheet 1
Selecting between two values in a query 6
HMS Queen Elizabeth using out-dated Windows XP 4
New linked table or not 4

Back
Top