Results 1 to 5 of 5
  1. #1
    Join Date
    Nov 2005
    Posts
    12

    How to Display parameter values on the report


    I have a report that is based on an underlying query.At the query level,I have defined parameters of date data type so that records to be displayed should fall between DateA and Date B.ie Between[Enter Date A:] And [Enter Date B:].How can I display these two parameter values on the report header???

  2. #2
    Join Date
    Dec 2005
    Location
    Wilmington, DE - USA
    Posts
    275
    In your report (probably in the report header or in the page header) put an unbound textbox, with this as the ControlSource:

    ="Data for dates between " & Format([Enter Date A:], "mmmm d, yyyy") & " and " & Format([Enter Date B:], "mmmm d, yyyy")

    The key is to use the exact same name for the parameters.

  3. #3
    Join Date
    Nov 2005
    Posts
    12
    Quote Originally Posted by matthewspatrick
    In your report (probably in the report header or in the page header) put an unbound textbox, with this as the ControlSource:

    ="Data for dates between " & Format([Enter Date A:], "mmmm d, yyyy") & " and " & Format([Enter Date B:], "mmmm d, yyyy")

    The key is to use the exact same name for the parameters.
    Thanks mathews.
    However, I have tried your solution but the output doesnt bound to the parameters entered.ie it shows records which are out of specified date range.
    I just cant figure out how would above expression is going to reflect the related Date control.

  4. #4
    Join Date
    Dec 2005
    Location
    Wilmington, DE - USA
    Posts
    275
    Please download the following file and see how I set up the report. It is a very simplistic example, but it illustrates the advice I gave you.

    http://www.geocities.com/matthewspat...rums255946.zip

  5. #5
    Join Date
    Nov 2005
    Posts
    12

    Thanks!

    Thanks very much mathews.it is working fine!!!

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

Similar Threads

  1. Enter Parameter Value
    By plesser in forum Access
    Replies: 1
    Last Post: 11-08-2008, 10:27 AM
  2. Replies: 0
    Last Post: 08-07-2008, 07:02 PM
  3. Replies: 1
    Last Post: 11-11-2006, 08:00 PM
  4. Date Parameter
    By shakira in forum Queries
    Replies: 2
    Last Post: 03-09-2006, 12:55 PM
  5. DISPLAY INPUT PARAMETERS ON THE REPORT
    By fadone in forum Forms
    Replies: 1
    Last Post: 12-09-2005, 10:26 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