Print requested date range on report

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.
 
D

Duane Hookom

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.
 
G

Guest

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.
 
D

Duane Hookom

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.
 

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