Include Date Range in header

[Guest]

I need help getting a date range to show up in a report header. My report is
based off of a query that uses a Between.. And date parameter and I would
like the starting date and ending date to show up in a text box at the top of
the report and I can't figure it out. Thanks, I appreciate any help I can
get.

 

[kingston via AccessMonster.com]

Create a dialog that asks for the dates and base your query on that instead
of using a parameter query. Your report can reference the input boxes in the
form with something like:
[Forms]![FormName]![TextBox1]

If you really are adverse to this, you can scan the query's data using DMin()
and DMax(), but this won't return the user's parameters, only the minimum and
maximum dates in the data set.

 

[Marshall Barton]

I need help getting a date range to show up in a report header. My report is
based off of a query that uses a Between.. And date parameter and I would
like the starting date and ending date to show up in a text box at the top of
the report and I can't figure it out.

If you are using pop up query paarameters like [Start Date]
and [End Date], then a report text box can display the range
by an expression like:
= "Data from " & [Start Date] & " through " & [End Date]

If the parameters are references to form text boxes then use
those same references instead of [Start Date] and [End Date]

 

[Guest]

Thanks for all the respones, the "= "Data from " & [Start Date] & " through
" & [End Date]" expression worked great.

I need help getting a date range to show up in a report header. My report is
based off of a query that uses a Between.. And date parameter and I would
like the starting date and ending date to show up in a text box at the top of
the report and I can't figure it out.

If you are using pop up query paarameters like [Start Date]
and [End Date], then a report text box can display the range
by an expression like:
= "Data from " & [Start Date] & " through " & [End Date]

If the parameters are references to form text boxes then use
those same references instead of [Start Date] and [End Date]