Results 1 to 3 of 3
  1. #1
    5 Star Lounger
    Join Date
    Mar 2001
    Posts
    989
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Referring to parameter values (2000)

    I have a report based on a parameter query. How can I display the parameter values that were entered on the report? Thanks, Andy.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Referring to parameter values (2000)

    Say that you have a parameter [Enter Quantity]. You can place a text box on your report with control source

    =[Enter Quantity]

    or

    ="Specified quantity: " & [Enter Quantity]

    If you have a date parameter, it'll be displayed exactly as you enter it, but you can use the Format function to display it the way you want:

    ="Report for " & Format([Enter Date],"dddd mmmm d, yyyy")

  3. #3
    5 Star Lounger
    Join Date
    Mar 2001
    Posts
    989
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Referring to parameter values (2000)

    Thanks. Andy.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •