Sub-Reports repeating Data

  • Thread starter Thread starter NigelP
  • Start date Start date
N

NigelP

I have created three queries that display the same sort of
data based on specific criteria, ie metro, branch or
country deliveries. I base these queries on a single date
and so the report gives me all the details seperated
neatly into three sections. The problem is that each time
I run the report I have to type in the date Three times.
and then again another three times to print it. Is there a
way were I can develop the report typing in the date once
and then whatever is on screen gets printed so as not to
have to type in the dates again?

Nigel
 
Have the queries read the date from a text box on the form, so you only have
to type it once.

Create a small, unbound form named "Form1".
Place a text box on the form, and give it these properties:
Name txtDate
Format Short Date

Now open your query in design view, and replace the parameter with:
[Forms]![Form1]![txtDate]
Repeat for the other queries.

It is also a good idea to declare this parameter in the queries, so Access
knows the intended data type. In query design view, choose Parameters from
the Query menu, and paste in the name
[Forms]![Form1]![txtDate]
Alongside that, tell Access it is a Date/Time type.
 
Back
Top