Problems with a report

[claudegarneau]

I've created a report based on a query. The report counts the number
of participants in a training program during a given period. To
determine the report start and end date, I use the Criteria filed in
the query. I used [Report Start Date] to query the training program
start date, and [Report End Date] to query the training program end
date. How can I display these report start and end dates on the
report? I'm sure I've done it in the past, but for the life of me, I
can't remember!!!

 

[Guest]

In the query design view grid add two more fields in the output like this --
My_Start: [Report Start Date]
My_End : [Report End Date]

I always copy the criteria element to make sure they are identical else you
will be prompted a second time.

 

[fredg]

I've created a report based on a query. The report counts the number
of participants in a training program during a given period. To
determine the report start and end date, I use the Criteria filed in
the query. I used [Report Start Date] to query the training program
start date, and [Report End Date] to query the training program end
date. How can I display these report start and end dates on the
report? I'm sure I've done it in the past, but for the life of me, I
can't remember!!!

Add an unbound control to the Report Header.
Set it's control source to:
="For training between " & [Report Start Date] & " and " & [Report End
Date]

Note... The text within the brackets must be identical to the
bracketed text in the query criteria.