Recalling Query parameter Values

S

Stan_B

I have a parameter query which requests start and stop dates to sort data
between these dates. Is there some way to recall this data (these dates) and
then print them onto the corresponding report? I'd like to include the start
and stop dates into the header of this report, what kind of field, along with
format and control source, could accomplish this feat?
 
D

Duane Hookom

You really should use controls on forms for parameters however you can use
the exact parameters in a control source in your report like:
="For Dates between " & [Enter Start Date] & " and " & [Enter End Date]
 
S

Stan_B

Thank You, Sir!

Duane Hookom said:
You really should use controls on forms for parameters however you can use
the exact parameters in a control source in your report like:
="For Dates between " & [Enter Start Date] & " and " & [Enter End Date]


--
Duane Hookom
MS Access MVP

Stan_B said:
I have a parameter query which requests start and stop dates to sort data
between these dates. Is there some way to recall this data (these dates)
and
then print them onto the corresponding report? I'd like to include the
start
and stop dates into the header of this report, what kind of field, along
with
format and control source, could accomplish this feat?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top