Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2010
    Location
    California
    Posts
    8

    Smile Unanswered: Displaying Date Range Parameter in Report Heading

    I have a sales report generated by a query. The date parameter is to enter a start and ending date for the report. Everything is functioning as it should. However I would like to show in the report header the dates selected. That is after the title SALES REPORT I would like to show the start date and the end date for the report that was used to generate the report.
    Thanks,
    Geno

  2. #2
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    I assume you're using the brackets method of gathering input, so a textbox with this type of thing will work:

    ="Data from " & [Enter start date] & " to " & [Enter end date]

    or simply:

    =[Enter start date]

    making sure that the text in the brackets exactly matches the text used in the query.
    Paul

Posting Permissions

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