Include Date Range in header

  • Thread starter Thread starter Guest
  • Start date Start date
G

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


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]
 
Thanks for all the respones, the "= "Data from " & [Start Date] & " through
" & [End Date]" expression worked great.



Marshall Barton said:
OmahaAccess said:
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.
Click to expand...


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