Sub-Reports

[PJShows]

Is it possible to have a report that pulls information from two sub-report but type the criteria in once.

IE: if both query's have Between[Start date] and [End Date]in the criteria.

Right now when I run the report you have to enter these areas in twice. Once for each query that runs. I want to enter them once. Does any one know of a way?

 

[JeremyNYC]

PJ,

Make a form with controls to hold the criteria. Open the report from a button on that form. Make your queries reference the contorls on the form, instead of waiting for you to enter data.

Jeremy =============
Jeremy Wallace
Designing, Developing, and Deploying Access Databases Since 1995

http://www.AlphaBetCityDataworks.com

Take a look at the Developer's section of the site for some helpful fundamentals.


Remember to reward helpful tips with the stars they deserve.

 

[PJShows]

OK, I see what your saying about creating the form.
But are you saying put the text box as the criteria in they query?

 

[JeremyNYC]

Yeah. In the criteria box you can do things like this:
forms!frmYadda!txtWhatever

Jeremy =============
Jeremy Wallace
Designing, Developing, and Deploying Access Databases Since 1995

http://www.AlphaBetCityDataworks.com

Take a look at the Developer's section of the site for some helpful fundamentals.


Remember to reward helpful tips with the stars they deserve.