Parameter query in a report

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?
 
J

jrt121

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]".
 
J

jrt121

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

print a date range from parameter query on a report header? 2
Parameter Query In Report Title 3
Date Range in Reports 2
Show Parameter Information in Report Footer 1
Parameter Query in Report Header 1
Display query parameters in a chart 5
Report Header Lookup Question 2
Prompt user to input what data to be displayed on Report 3

Top