• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 447
  • Last Modified:

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
0
tmaususer
Asked:
tmaususer
  • 3
1 Solution
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
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
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
Also, be SURE the part in bold below exactly matches your prompts in the query:

="Between " & [start date] & " and " & [end date]
0
 
tmaususerAuthor Commented:
Thanks so much. Now I'm hoping to do the same with a graph
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
Hope is good :-)
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now