Date range

  • Thread starter Thread starter Frank
  • Start date Start date
F

Frank

One other question I forgot to mention. I have a report
that runs off a parameter query. How do I display the
parameters on the report (Date range). For example, I
type in 01/01/04 to 01/08/04. I would like that on the
report somewhere.

Thanks,

Frank
 
Frank said:
One other question I forgot to mention. I have a report
that runs off a parameter query. How do I display the
parameters on the report (Date range). For example, I
type in 01/01/04 to 01/08/04. I would like that on the
report somewhere.
Click to expand...

Use a text box in the report header section. Set its
control source expression to something like:

=[Start Date] & " to " & [End Date]

Replace the [Start Date] and [End Date] with EXACTLY the
same things you have in the query.
 
Back
Top