Date range on a report msaccess 2003

I have a report based off a query. In the query I setup a date criteria which is Between [start date] And [end date]. The report works but what I don't know how to do (of know if its possible) would be to place the dates I listed in the criteria in the heading of the report.

Can someone walk me through those steps as I am not a programmer. I also attached at copy of my db if that makes it easier. The name of the report is Report2 and the query is Calculation_qry
Safety-new-2x.mdb
tmaususerAsked:
Who is Participating?
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
Also, be SURE the part in bold below exactly matches your prompts in the query:

="Between " & [start date] & " and " & [end date]
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
Create a text box in the heading, with a Control Source like this:


="Between " & [start date] & " and " & [end date]

Note that you can use use what ever 'text' you like, EG:

="FROM" & [start date] & " TO" & [end date]

Don't forget the equals sign ...

mx
0
 
tmaususerAuthor Commented:
Thanks so much. Now I'm hoping to do the same with a graph
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
Hope is good :-)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.