Report Problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a report with 3 subreports. Each subreport pulls its info from a query. I have tried doing just 1 query for everything but the data does not come out correctly.
On each query I have an expression that prompts the user for the number of the month. The 3 subreports are in a group header which is the expression also.
How can I get it to prompt for the month just once. Right now it prompts for the month too many times.

Thanks!

John
 
Create a form where you enter or select the month's
number. In the queries for your report you enter the form
and text box in the criterion.
Hope this helps.
Fons
-----Original Message-----
I have a report with 3 subreports. Each subreport pulls
Click to expand...
its info from a query. I have tried doing just 1 query
for everything but the data does not come out correctly.
On each query I have an expression that prompts the user
Click to expand...
for the number of the month. The 3 subreports are in a
group header which is the expression also.
How can I get it to prompt for the month just once.
Click to expand...
Right now it prompts for the month too many times.
 
Back
Top