Print requested date range on report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a report generated from a query that prompts the user to enter a date
range to obtain specific data. The criteria for the Date field is: Between
[Enter beginning date] And [Enter ending date]

Is it possible for those same dates that are entered to appear on the report
itself so they can be seen when printed? Right now, you enter the criteria
and get the data, but anyone else looking at a printed report would not know
what date range the data applied to.
 
You can add a text box to your report with a control source of:
="Between " & [Enter beginning date] & " And " & [Enter ending date]

I strongly recommend using controls on forms for criteria rather than
parameter prompts.
 
I have not used controls much. Could you please point me in the right
direction as to what to look up in Help to find out more information. Thank
you.


Duane Hookom said:
You can add a text box to your report with a control source of:
="Between " & [Enter beginning date] & " And " & [Enter ending date]

I strongly recommend using controls on forms for criteria rather than
parameter prompts.

--
Duane Hookom
MS Access MVP


Kathy said:
I have a report generated from a query that prompts the user to enter a
date
range to obtain specific data. The criteria for the Date field is:
Between
[Enter beginning date] And [Enter ending date]

Is it possible for those same dates that are entered to appear on the
report
itself so they can be seen when printed? Right now, you enter the
criteria
and get the data, but anyone else looking at a printed report would not
know
what date range the data applied to.
Click to expand...
Click to expand...
 
Open Help and search for "Text Box".

--
Duane Hookom
MS Access MVP
--

Kathy said:
I have not used controls much. Could you please point me in the right
direction as to what to look up in Help to find out more information.
Thank
you.


Duane Hookom said:
You can add a text box to your report with a control source of:
="Between " & [Enter beginning date] & " And " & [Enter ending date]

I strongly recommend using controls on forms for criteria rather than
parameter prompts.

--
Duane Hookom
MS Access MVP


Kathy said:
I have a report generated from a query that prompts the user to enter a
date
range to obtain specific data. The criteria for the Date field is:
Between
[Enter beginning date] And [Enter ending date]

Is it possible for those same dates that are entered to appear on the
report
itself so they can be seen when printed? Right now, you enter the
criteria
and get the data, but anyone else looking at a printed report would not
know
what date range the data applied to.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top