I have a report with two subreports. the main report and each subreport is based on it's own query. each query has a parameter for "subject" and the 2 subreports also have parameters for dates. when I run the report it asks for the subject three times and for the dates two times. How do I change this so that it asks only once for each parameter?

Create a form. But unbound text fields on the form for each parameter in each query. In the criteria field(s) of the queries refer to the form, i.e. [Forms]![MyForm]![Subject]. Fill in the the dates, etc. then open your report from the form.

Thanks Much! this works great now all I have to do is tie it to my report! what's the easy way to start the report when I enter the last(End) date? I'm entering "subject", Start Date and End date

Create a command button using the Wizard to open your report. That should do it.

Thank you. This solved my problem.