Saving Query Criteria For Use Later

[Neil Warwick]

I have a report that is based on a query that uses the []
option to bring up a dialog box where the user can input
any date he or she chooses.

Is there a way I can store the date entered, so that I can
use it in the header of the report.

Thanks

Neil

 

[fredg]

I have a report that is based on a query that uses the []
option to bring up a dialog box where the user can input
any date he or she chooses.

Is there a way I can store the date entered, so that I can
use it in the header of the report.

Thanks

Neil

You don't have to store it.

Let's assume the query parameter is

=[Enter Date]

Add an unbound control to the Report Header.
Set it's control source to:
= "For sales on or after " & [Enter Date]

The bracketed text in the control must be identical to the bracketed
text in the query.

 

[Guest]

Thanks Fred,

Can't believe it was so easy!

-----Original Message-----

I have a report that is based on a query that uses the []
option to bring up a dialog box where the user can input
any date he or she chooses.

Is there a way I can store the date entered, so that I can
use it in the header of the report.

Thanks

Neil

You don't have to store it.

Let's assume the query parameter is

=[Enter Date]

Add an unbound control to the Report Header.
Set it's control source to:
= "For sales on or after " & [Enter Date]

The bracketed text in the control must be identical to the bracketed
text in the query.

--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
.