Access query to find a value between two fields

[wayneryeven]

Hey all
i have a table that records the following data:

Product A
Start ID: 1
End ID: 50

What this table is recording is that we shipped 50 of Product A and their IDs were between 1 and 50.

What i would like to do is to query this table and ask where was ID 40 used? It would therefore return Product A - as 40 falls between 1 and 50.

Is this the correct way to structure the table?
If so how could a query satisfy this?

Guys, many thanks for your time and effort.

 

[wayneryeven]

got it..

<=[forms]![frmReports]![ID] and >=[forms]![frmReports]![ID]

searches and retrieves the data i require on entry of an ID.