Query on a range

[DJM1216]

'Evening everyone...

I have a table of all cities in a state with their valid zip codes. For example a record would have three columns, city name, low zip, high zip.

Anytown 11111 11125

I need to run a query on one zip (example 11120), is there a way to write a query to look at both zip columns and determine if the zip I'm querying on falls within those two values?

Please let me know if you need any further information....and thanks in advance for your help!

 

[bat17]

Just check the number against both columns, ie. >= 11120 in the first column and <= 11120 in the second.
You will probably want to set up a parameter in the query or call it from a form to avoid having to enter the zip code twice.

HTH

Peter

 

[DJM1216]

Yes, but wouldn't that result return every number greater than or equal to 11120?

 

[DJM1216]

Never mind I know what yuo mean now.