Displaying date parameters on the report

  • Thread starter Thread starter Maureen227
  • Start date Start date
M

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


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]
 
Marshall said:
Maureen227 said:
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?
Click to expand...


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]
Click to expand...

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