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!