Report Problem

[John]

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

 

[Fons Ponsioen]

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

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.