Parameter Query Input To Report

Are you entering the SAME dates 6 times? There is no reason for that and my answer will not only eliminate that but accomplsih what you are asking.

Create a form (call it SelectDates) and put 2 unbound text boxes on it. Call them txtStart and txtEnd. Then go to each of your queries and put the following as the criteria for your date fields:

BETWEEN Forms![SelectDates]![txtStart AND Forms![SelectDates]![txtEnd].

Next put a Command button on your form to run your report. In the report put 2 unbound text boxes where you want the dates to appear. I usually put them in the report header. In the first box, I make the DataSource; =Forms![SelectDates]![txtStart] set the label to "From". In the second box I make the DataSource; =Forms![SelectDates]![txtEnd] and make the label "To".

Now, when you open that form, you enter the dates just once and each query pulls the dates from the form and they show up on the report.

Hope this helps,
Scott<>

Please don't forget to provide feedback for this response (either by rating or followup). It helps me help people better if I know how my advice worked.