I have developed a report in Access 2007 that runs on three queries, each promting an input from the user...this report is used for a meeting and it should be printed nine times...what I do now is open the report nine times, with each print i enter the same inputs for the first two queries and a different input for the third one...so this is becoming a hassle for me.. :(
Query1 takes the meeting date
Query2 takes the budget date
Query3 takes the member's ID ( the list of ID's is stored in a table in the database)
so in each print, the only difference is the member's ID...but now I enter the meeting date and the budget date again and again for each print.. :(
is there a way to have a loop that takes the input for the first two queries once and stores it in a variable, and reads the value for the third query from the table (with each cycle it reads the next record and gives it to the query, instead of promting the user to enter it)?...
Or atleast save the inputs for the 1st two queries and prompt only for the member's ID..
I am really desperate to have this Loop...thanks
p.s I dont have any experience in VB programming