Parameter query in a report

  • Thread starter Thread starter Edmund Wong
  • Start date Start date
E

Edmund Wong

I have a report based on a query prompting for a start and end date.
Is is possible to have those dates appear in the report header?
 
p said:
just put them there
Click to expand...

Do you have a form that you enter the dates into? If so, place an
unbound text box in the header and set the data property to "Between
Forms![Form Name}![Start Date] And Forms![Form Name]![End Date]".
 
Do you have a form that you use to enter the dates?
If so, place an unbound text box into the header. Under properties,
data tab, set control source to :
="For the period of " & Format([Forms]![Form Name]![Beginning
Date],"mmmm d"", ""yyyy") & " to " & Format([Forms]![Form Name]![Ending
Date],"mmmm d"", ""yyyy")

Hope this helps.
 
Back
Top