Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Mar 2001
    Location
    Cheltenham, Gloucestershire, England
    Posts
    214
    Thanks
    0
    Thanked 0 Times in 0 Posts

    putting parameter query info in report header (Access 2000)

    We use a parameter query to create a regular report.

    However, we would like the Between [Start date] And [End date] selected to be recorded in our report header. These exact dates may not exist in the record set.

    Any suggestions as to how we can get them so the header reads Reports from [start date] to [end date].

    Many thanks

  2. #2
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: putting parameter query info in report header (Access 2000)

    You are almost there. Create a control in the header and put the following in the Source:

    ="Reports from " & [start date] & " to " & [end date]

    HTH
    Pat

Posting Permissions

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