I need to create Gift Certificates that can be printed out every month, approx 25 per month. The db needs to keep track of the previous control No's, so as to continue from last months control No. I am new to Access. I have the form made. My query can find the next Control No. but can't select the next 25 Certificates, and can't set the Yes/No field in the table as being previously used.


Any suggestions?