Adding query prompt values to a report

RaunLGoode

Registered User.
Local time
Yesterday, 21:30
Joined
Feb 18, 2004
Messages
122
This has to be a pretty common need.
I have a query that prompts the user for a start & stop date:
Example: (query Criteria) "Between [Start Date] and [Stop Date]"
I would like to be able to display these two input values in the header of the report so the title can reflect the date choices
Example:(report Header) Project Costs Between [Start Date]and [Stop Date].
Whats the best / easiest way to do this?
Thanks.
 
="Project Costs Between " & [Start Date] & " and " & [Stop Date]

Note that the spelling must be exactly the same as the 2 query criteria inputs.
 
Thanks for the help

Sorry for the delay, other projects, But this did the trick,I really appreciate it
Thx again
 

Users who are viewing this thread

Back
Top Bottom