31
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 I can enter the input for the first two queries once..like store it in a variable and only enter the input of the third query nine times?...
Also.. the input of the third query is in a table..so 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)?...
I am really desperate to have this Loop...thanks
p.s I dont have any experience in VB programming
