Report building

  • Thread starter Thread starter TBird
  • Start date Start date
T

TBird

I have a report built off of a query. I have it set up to prompt me for
start and stop dates (dd mmm yy) for the values to display. Now what I
would like to do is have the month and year that are input for start
and stop to be printed in the header to show the period of the report.
How do I do this?
 
If you meant you have [StartDate] and [StopDate] as the Parameter in the
Query being used as the RecordSource for the Report, then you can place a
TextBox in the Report Header Section with ControlSource like:

= "Report from " & [StartDate] & " to " & [StopDate]

Make sure you use exactly the same spelling as in the Query.
 
Back
Top