I have a simple database run off of an excel spreadsheet that generates dates that a particular job needs to be done. I run it once a week to tell me what needs to be done the next week. The data is added to as new work is added each week. The excel spreadsheet has fields that are calculated by the dates- ex. 11/12/11+3 would generate in the cell 11/15/11.
I set up queries to look at each column of results (work task) and tell me which experiments are ready for that task. I then have one report that runs grabbing each query individually and prompting for a date range for the week. I have 6 of these so when I run the report I enter the same start date 6 seperate times and the same end date 6 seperate times.
How do I enter the date only once for the whole report?
I tried using the wizard to group them all together, but if they run together it knocks them out if it was a null for the previous column.
Example of excel sheet
Experiments Step 1Step 2Step 3Step 4Step 5Step 6Step 7Experiment 110/31/201111/6/201111/27/201112/2/201112/13/201112/23/20111/2/2012Experiment 210/31/201111/6/201111/27/201112/2/201112/13/201112/23/20111/2/2012Experiment 310/31/201111/6/201111/27/201112/2/201112/13/201112/23/20111/2/2012
If anyone can help or point me in the direction of help, I will appreciate it.
Thanks
Lacey