Results 1 to 2 of 2
  1. #1
    jassie is offline Advanced Beginner
    Windows 7 64bit Access 2007
    Join Date
    Jan 2012
    Posts
    40

    input parameters

    I am asking this question since I am new to working with Access 2007, but I have worked with other databases like oracle, sql server, and db2.

    I basically would like to run a report where it takes in two date paramters. One would be start date and the other would be end date. I would like to use these two parameters to complete the following tasks:
    1. The date range would be the slection criteria used in the query to pick a date range for the data that is selected in the query.
    2. I would like to also have the range range appear as part of the header of the report.

    Thus can you tell me and/or point me to a reference that will tell me how to complete my goals of using a start date and and end date as input parameters?

  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
    The OpenReport command supports both a WhereCondition parameter and an OpenArgs argument. Use the WhereCondition to apply a filter to the Report's RecordSource and the OpenArgs to pass those same values to the Open event where you can set variables thet you use in the Header of the Report.

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

Similar Threads

  1. Replies: 2
    Last Post: 08-01-2011, 09:40 AM
  2. Parameters
    By Alaska1 in forum Access
    Replies: 1
    Last Post: 03-30-2011, 02:05 PM
  3. Too few parameters
    By jgelpi16 in forum Programming
    Replies: 1
    Last Post: 12-23-2010, 10:28 AM
  4. DISPLAY INPUT PARAMETERS ON THE REPORT
    By fadone in forum Forms
    Replies: 1
    Last Post: 12-09-2005, 10:26 PM
  5. Input parameters
    By GloriaLuz in forum Reports
    Replies: 0
    Last Post: 11-14-2005, 09:38 PM

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