Hi all, I have a database I designed but don't have much experience at all working with Access. I was able to figure most of it out but there is one function I cannot get to work. Currently I have a button for printing out records, each record has the unique ID as its "StrainID". For example if I want to print out a certain strain you just type in the ID of that strain e.g. IU13922 and then press enter.
However, I want to also be able to print out a report for a certain range of ID's. For example I want all the strains from IU13922-IU13928. I have included my database below as it is setup a bit strangely, as each strain is "paired" with the next sequential number as we store them in duplicates. Since they are paired like this when I enter a range I really want it to print all the even records. If I want the range from IU13922-IU13928, I really just want to print records IU13922, 24, 26, and 28 because each report prints out the even number and the next strain as they are almost identical.
Hopefully this make some sense, I apologize as I don't have a background in Access at all. If you can offer any advice as how to do this that would be great. Thank you so much in advance!
DB.zip