Results 1 to 4 of 4
  1. #1
    recon2011 is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Jul 2011
    Posts
    28

    Getting a date range to show on a report

    I have a report that opens from a date-range form. The results returned in the report are based on a range of dates selected using the date picker on the date-range form. I would like the dates selected to show on the report but I do not know how to set up a field on the report to reflect the dates selected. Anyone have a suggestion? Thanks in advance.

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    I did this by passing the dates to the Report in the OpenArgs argument and then storing them in public report variables in the Open event. the Report uses those variables in the header of the report.

  3. #3
    recon2011 is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Jul 2011
    Posts
    28
    I am not that familiar with code and do most everything from macros. I am more of an intermediate user. I understand what you are saying, just not how to do it. Thanks.

  4. #4
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Here's a link that may help: http://www.baldyweb.com/OpenArgs.htm

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Code to combine report filter and date range
    By rhubarb in forum Reports
    Replies: 17
    Last Post: 10-28-2011, 03:08 PM
  2. Criteria to show date range
    By Douglasrac in forum Queries
    Replies: 2
    Last Post: 03-24-2011, 03:58 PM
  3. Replies: 13
    Last Post: 09-27-2010, 03:10 PM
  4. Define a date range for a report - Help
    By Optimus_1 in forum Access
    Replies: 4
    Last Post: 06-02-2010, 04:50 AM
  5. Replies: 3
    Last Post: 09-29-2009, 07:08 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums