I have a report that is queried by the ID # of a student - I have the following in the criteria of the query -
[Record ID 1] Or [Record ID 2] Or [Record ID 3] Or [Record ID 4] Or [Record ID 5] Or [Record ID 6] Or [Record ID 7] Or [Record ID 8] Or [Record ID 9] Or [Record ID 10]
This naturally prompts me to input 10 individual ID #'s. This works well; however, there are some instances where I only need 2 records as opposed to 10 whereas I input the first, then the second and then continue hitting the enter key until i have reached 10- then the report runs. There are also occassions when I need to pull more than 10 records whereas - I run the first query, print my reports and then run it again to get the additional records
Is there another way to write the criteria or to stop the query after the records needed rather than continuing to hit the enter key or to continue past the 10th record without adding [Record ID 11] and so forth?
As, I mentioned - this format is working well - I was just curious if it could prompt me to enter as many as I need and end when I've entered as many as I need.