Report Date Range

[knowshowrosegrows]

I have a report based on a date parameters query that asks for the Between
[Enter Start Date] And [Enter End Date] criteria in the date field. That is
great.

Now when I run the report it prompts for date range and gives me appropriate
data.

How do I put a label or text box in the report that identifies the date
criteria the report was run on?

 

[Rick Brandt]

I have a report based on a date parameters query that asks for the
Between [Enter Start Date] And [Enter End Date] criteria in the date
field. That is great.

Now when I run the report it prompts for date range and gives me
appropriate data.

How do I put a label or text box in the report that identifies the
date criteria the report was run on?

Put a TextBox on the report with a ControlSource of...

="Date Range: " & [Enter Start Date] & " to " & [Enter End Date]

Change the text portions as desired. What is between the square brackets
has to match exactly the text you used in the query parameter markers.

 

[KARL DEWEY]

Another way is to add output fields in the query like this --
Start Date: [Enter Start Date] End Date: [Enter End Date]
Just make sure it is exactly as in criteria (i always copy and paste) so
there are not multiple prompts.
--
KARL DEWEY
Build a little - Test a little

I have a report based on a date parameters query that asks for the
Between [Enter Start Date] And [Enter End Date] criteria in the date
field. That is great.

Now when I run the report it prompts for date range and gives me
appropriate data.

How do I put a label or text box in the report that identifies the
date criteria the report was run on?

Put a TextBox on the report with a ControlSource of...

="Date Range: " & [Enter Start Date] & " to " & [Enter End Date]

Change the text portions as desired. What is between the square brackets
has to match exactly the text you used in the query parameter markers.