Displaying date parameters on the report

[Maureen227]

I have a report that request a date range parameter from the user. The
prompt comes from the query Criteria: Between [Enter Beginning Date]
And [Enter Ending Date]

I would like to display the dates parameters on the form in a text box.
Is this values store in a system variable I can access?

Thanks ahead for your help.

 

[Marshall Barton]

I have a report that request a date range parameter from the user. The
prompt comes from the query Criteria: Between [Enter Beginning Date]
And [Enter Ending Date]

I would like to display the dates parameters on the form in a text box.
Is this values store in a system variable I can access?

Use a text box in the report and refer to the prompt strings
as if they were fields in the query. E.g.

="Sales from " & [Enter Beginning Date] & " through " &
[Enter Ending Date]

 

[Maureen227]

I have a report that request a date range parameter from the user. The
prompt comes from the query Criteria: Between [Enter Beginning Date]
And [Enter Ending Date]

I would like to display the dates parameters on the form in a text box.
Is this values store in a system variable I can access?

Use a text box in the report and refer to the prompt strings
as if they were fields in the query. E.g.

="Sales from " & [Enter Beginning Date] & " through " &
[Enter Ending Date]

-- Marsh
MVP [MS Access]

Marsh
Terabytes of thanks for your quick reply.
This worked great!!!
I was trying to put it in code instead in the control source for the
text box.
Maureen