That's actually two prompts.
You could use a text box expression like:
="Between " & [From? (MM/DD/YYYY)] & " And " & [TO?
(MM/DD/YYYY)]
Use Copy/Paste from the query to the expression to make sure
the above expression has the **exact** same strings as the
query.
--
Marsh
MVP [MS Access]
How do I refer to the parameter? My prompt is written as >=[From?
(MM/DD/YYYY)] AND <= [TO? (MM/DD/YYYY)]
Marshall Barton said:
Saving it is not really viable.
OTOH, you can easily display it in a report text box just by
referring to the parameter as if it were a field in the
query.
lfcjr wrote:
I have a query which prompts for a date range. I would like to be able to
save the user's response and use the range in the title of a report. Is this
possible?
