Date range

[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

 

[Marshall Barton]

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.

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.