Passing multiple parameter dates to subreports for computation to main report

[eipts]

Hi all,

I'm a novice to Access and programming in general so please bare with me.

I have several queries from different databases in a linked table database, each of which has its own report. The purpose is for the user to set a date parameter and find out which products have failed production and which have passed. Thus, each has a date parameter and a footer calculation that sums up total and failed. The queries are all unrelated to each other.

Now, I need to combine all of those reports together. I have an unbounded main report that is housing all of the subreports for them to be ultimately summed up individually and put back into 2 text boxes in the main report.

The problem is when main report is run, the user has to type in start and end dates about 10 times which is very annoying.

I would like to make it so entering in one date automatically filters each individual report and does the calculations behind the scenes.

Does anyone know what the best way to go about this would be? I'm not even sure where to start.

[eipts]

Some more information:

The tables are pulled form 10 different databases so there is no single database for the query. Each table is is completely unrelated to the other table. Each query is based on its corresponding table and each report on its corresponding query. The purpose of the linked table is that the data will be changing in the future from the different databases.

[Rabbit]

Use a form to input the dates with a button to open the report. Change the queries to use the date inputted on the form.