Date Display

[daherb]

I am building a report at the moment from the results of a query. as part of the query i have created an expression which limits the records displayed. This is done by using the following expression

BETWEEN [START DATE] AND [END DATE]. in order to run the report i have to input the start and end date.

What i want to know is, Is it possible to have a field on the report that displays the start and end date that i enter so that i always know the period the report is showing me ??


Please help

 

[ThreeCrow]

Put a control on you Report

As the Data Source for this Control use

=[Forms]![YourFormName].[Start Date]&" Through "&[Forms]![YourFormName].[End Date]

YourFormName = the name of the Form that you used to Select the Dates.


Hope this helps