Combining 2 parameter values

[Guest]

I have 2 reports, proposal and project
both of them came from 2 different queries
everytime I click in proposal report it will ask me which month I would like
to report the proposal, same thing as the project report.

I want to create a report where I can combine both reports, however it asks
twice for which month i would like the report for. How do I combine them so
that it will only ask me once.

Thanks

 

[fredg]

I have 2 reports, proposal and project
both of them came from 2 different queries
everytime I click in proposal report it will ask me which month I would like
to report the proposal, same thing as the project report.

I want to create a report where I can combine both reports, however it asks
twice for which month i would like the report for. How do I combine them so
that it will only ask me once.

Thanks

Just use a form to enter the parameters in.
As long as the form is open, it's criteria parameters will be
available to all queries.
You can adapt the following.....
Create an unbound form.

Also add an unbound text control.

Name it "WhatMonth"

Add a Command Button to the form.
Code the button's click event:

Me.Visible = False

Name this form 'ParamForm'.

As criteria in the query field write:
forms!Paramform!WhatMonth

Next, code the report's Open event:
DoCmd.OpenForm "ParamForm", , , , , acDialog
Note: If you are running several reports consecutively, just place the
Open code in the first report's Open event.

Code the report's Close event:
DoCmd.Close acForm, "ParamForm"
Note: If you are running several reports consecutively, just place the
Close code in the final report's Close event.

When ready to run the report, open the report.
The form will open and wait for the entry of the Month wanted.
Click the command button and then report will run.
When the report closes, it will close the form.