Print Dates entered in parameter

T

Terry

Can someone help me with adding a field to a report that
will automatically fill with the Begin and End dates
entered when opening the report. The query behind the
report prompts for a date range which I need to see on the
report.
 
R

Rick

add an unbound text box with something like the following:

=format([Begin],"short date") & " through " &format([End],"short date")

Replace "Begin" and "End" with whatever prompt your query is using.

Rick

Can someone help me with adding a field to a report that
will automatically fill with the Begin and End dates
entered when opening the report. The query behind the
report prompts for a date range which I need to see on the
report.
 
G

Guest

Create expressions in your query for the parameter values:

Ex. InptDt:[Enter start Date]

Then, you have InptDt as a field in your query that you
can access in your report.
 
Top