Date range on a report msaccess 2003

Posted on 2012-08-27
Last Modified: 2012-08-27
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
Question by:tmaususer
    LVL 75

    Expert Comment

    by:DatabaseMX (Joe Anderson - Access MVP)
    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 ...

    LVL 75

    Accepted Solution

    Also, be SURE the part in bold below exactly matches your prompts in the query:

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

    Author Comment

    Thanks so much. Now I'm hoping to do the same with a graph
    LVL 75

    Expert Comment

    by:DatabaseMX (Joe Anderson - Access MVP)
    Hope is good :-)

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Threat Intelligence Starter Resources

    Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

    Suggested Solutions

    In the previous article, Using a Critera Form to Filter Records (, the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
    QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
    Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
    In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now