Show Parameter Query Value in a report 1

[ychousa]

Hi.

I made a parameter query which asks start date and end date and show some statistics in a report.

What I want to do is to show the start date and end date on the report, maybe on the report head section something like From [Start date] To [End Date].

How would I do it?

Thanks.

 

[scriverb]

Simply use the exact parameter prompt from your query in the Control Source for your reports textbox's.

=[Start Date]

=[End Date]

As long as you use the exact syntax that you used in the query the value will follow forward to the control.

Bob Scriver
Want the best answers? See FAQ181-2886
Nobody believes the official spokesman... but everybody trusts an unidentified source.
Author, Bagdad Bob???

 

[ychousa]

Thanks, scriverb.

It worked beautifully.

 

[scriverb]

Great!!!

Thanks for the STAR! Much appreciated.

Bob Scriver
Want the best answers? See FAQ181-2886
Nobody believes the official spokesman... but everybody trusts an unidentified source.
Author, Bagdad Bob???