Date in Report Headings

  • Thread starter Thread starter Dave van Wagenen
  • Start date Start date
D

Dave van Wagenen

I have written a make table query which extracts a sub-set of my data based
on an input starting and ending date.
example 01/01/03 thru 03/31/03 for the 1st quarter or 01/01/03 thru 09/30/03
for year-to-date.

I would like these date parameters to appear in my report headings, but
don't have a clue on how to get them there.

I have a number of different reports such as number of clients severed
during the period: by age, by gender, by ethnicity, change in confidence
level pre and post training. So I'm guessing that I need to store the dates
in a separate table or something so the reports can find them.

Thanks for the help!!!
 
Dave,
Regarding:
extracts a sub-set of my data based
on an input starting and ending date.
Click to expand...

Input where? How?

If the query criteria is written as:
Between [Enter Start Date] And [Enter End Date]
then add an unbound control to the report header.
Set it's control source to something like:
= "For Sales between " & [Enter Start Date] & " And " & [Enter End Date]
The text within the brackets must be identical to the bracketed text in the
query.

If the parameters are add via a form, then
= "For Sales between " & Forms!FormName!StartControl & " And " &
forms!FormName!EndControl
The form must be open when the report is run.
 
Back
Top