Including date selections on report at runtime

  • Thread starter Thread starter Guest
  • Start date Start date
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?
 
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?
Click to expand...

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.
 
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?
Click to expand...

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.
Click to expand...
 
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?
Click to expand...

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.
Click to expand...
 
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?
Click to expand...

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.
Click to expand...
Click to expand...
 
Back
Top