Report from Parameter query

[DK]

I am using a Parameter query to generate a report in
Access 2002. My parameter query has two criteria, a START
DATE and END DATE.

My question is as follows - can i include somewhere in
the report the start date and end date based on which i
have created the report? for example, my report generates
records from 10/1/03 to 11/1/03. Can I include these two
dates on my report so that whenever i generate a report
on a similar parameter, the exact time period is shown in
my report as well as.

thx.

DK

 

[Marshall Barton]

I am using a Parameter query to generate a report in
Access 2002. My parameter query has two criteria, a START
DATE and END DATE.

My question is as follows - can i include somewhere in
the report the start date and end date based on which i
have created the report? for example, my report generates
records from 10/1/03 to 11/1/03. Can I include these two
dates on my report so that whenever i generate a report
on a similar parameter, the exact time period is shown in
my report as well as.

Just use the **exact** same parameter names in one or more
text boxes the same as if they were fields in the query.
E.g.

="Data from " & [START DATE] & " to " & [END DATE]

 

[ryan13]

You should be able to add a text box on the report and set the source
code to be the field where the dates are entered. For example, if you
have a form and the dates are entered into a text box, your source code
should be:



[Forms].[Formname]![txtstartdate]



Ryan