Displaying a date range in my report

[Anne]

I have a report run where I select the records based on the date a service
was performed. My query asks for a range with a start and end date on this
field. How can I show this range on my report?

 

[fredg]

I have a report run where I select the records based on the date a service
was performed. My query asks for a range with a start and end date on this
field. How can I show this range on my report?

Exactly what are the query parameters?

Let's say it is
Between [Start Date] and [End Date]

In the Report header, add an unbound text control.
Set it's control source to something like:

="For sales between " & [Start Date] & " and " & [End Date]

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

 

[Anne]

Thanks, just had to change the text to reflect my fields. It worked like a
charm.
--
Anne

I have a report run where I select the records based on the date a service
was performed. My query asks for a range with a start and end date on this
field. How can I show this range on my report?

Exactly what are the query parameters?

Let's say it is
Between [Start Date] and [End Date]

In the Report header, add an unbound text control.
Set it's control source to something like:

="For sales between " & [Start Date] & " and " & [End Date]

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