Possible to Input a Range and then Query within that Range?

[1copse]

I have little experience with Access. I work in the legal field and I am designing a database to organize and track CDs of discovery we are receiving from opposing counsel.



Each CD contains documents and each page of each document is assigned a unique number. An individual CD will contain any number of documents (from < 10 to several thousand), and each CD is labeled with the range of document numbers it contains (e.g. CD #7 contains Doc. pgs 7656 - 8902).

What I want to do is run a query for a specific document page (e.g. page 7998) and find the CD that contains it.

Is it possible to enter a range and then query for a number within that range? If so, how?

Thanks in advance!

[pbaldy]

Presuming the page numbers are part of the data, like:

CDNum    StartPage    EndPage
  7      7656          8902

It would be a simple matter to find the CD associated with a page.