Report from Parameter query

  • Thread starter Thread starter DK
  • Start date Start date
D

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
 
DK said:
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.
Click to expand...

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]
 
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
 
Back
Top