Including date selections on report at runtime

G

Guest

I have a report that is based on a query. The report prompts the user to
enter a "From" and a "Through" date, then the report processes. I would like
to add unbound text boxes to the report header and pass the "From" and
"Through" dates from the query selection to the text boxes.

So my question is: can date selection parameters be passed through to the
report header at runtime?
 
R

Rick Brandt

Robert said:
I have a report that is based on a query. The report prompts the user
to enter a "From" and a "Through" date, then the report processes. I
would like to add unbound text boxes to the report header and pass
the "From" and "Through" dates from the query selection to the text
boxes.

So my question is: can date selection parameters be passed through to
the report header at runtime?

If you use ControlSource entries of...

=[Parameter]

....and instead of "Parameter" you use the exact same text as the parameter
markers in your query your report will display whatever the user enters.
 
G

Guest

Tried it. Works great. Thanks.
--
Robert Robinson


Rick Brandt said:
Robert said:
I have a report that is based on a query. The report prompts the user
to enter a "From" and a "Through" date, then the report processes. I
would like to add unbound text boxes to the report header and pass
the "From" and "Through" dates from the query selection to the text
boxes.

So my question is: can date selection parameters be passed through to
the report header at runtime?

If you use ControlSource entries of...

=[Parameter]

....and instead of "Parameter" you use the exact same text as the parameter
markers in your query your report will display whatever the user enters.
 
G

Guest

hi rick, i am trying to do this also and putting Between [BEGINNING DATE] And
[ENDING DATE] instead of Parameter but no luck, can you help.
thanks.
Pauline.

Rick Brandt said:
Robert said:
I have a report that is based on a query. The report prompts the user
to enter a "From" and a "Through" date, then the report processes. I
would like to add unbound text boxes to the report header and pass
the "From" and "Through" dates from the query selection to the text
boxes.

So my question is: can date selection parameters be passed through to
the report header at runtime?

If you use ControlSource entries of...

=[Parameter]

....and instead of "Parameter" you use the exact same text as the parameter
markers in your query your report will display whatever the user enters.
 
D

Duane Hookom

Try a control source like:

="Between " & [BEGINNING DATE] & " And " & [ENDING DATE]

--
Duane Hookom
MS Access MVP

paulineT said:
hi rick, i am trying to do this also and putting Between [BEGINNING DATE]
And
[ENDING DATE] instead of Parameter but no luck, can you help.
thanks.
Pauline.

Rick Brandt said:
Robert said:
I have a report that is based on a query. The report prompts the user
to enter a "From" and a "Through" date, then the report processes. I
would like to add unbound text boxes to the report header and pass
the "From" and "Through" dates from the query selection to the text
boxes.

So my question is: can date selection parameters be passed through to
the report header at runtime?

If you use ControlSource entries of...

=[Parameter]

....and instead of "Parameter" you use the exact same text as the
parameter
markers in your query your report will display whatever the user enters.
 

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