Range of Numbers

[MythMagic]

I've set up a database to store serial numbers of
products. Now I'm trying to figure out how to input the
serial number(s) or configure a query to enable finding a
serial number within a range (e.g. to find 35 in a range
between 25-40; in other words, the serial number field
would have 25-40 entered). When I do a query I want to
enter 35 and pull up the record related to 25-40, which
contains the 35.

Do I need to enter the numbers in the range (e.g. 25, 26,
27, etc.) or is there a way to enter the range some other
way so that a query would recognize that a number is
within a range?

Any help would be appreciated.

 

[Jeff Boyce]

Take a look at the "Between xxx And yyy" expression as a criteria in a query
design grid. You could even turn that into a parameter query, so that it
would prompt for each time it ran.

Good luck

Jeff Boyce
<Access MVP>