Printing parameters on reports

[jcdifi26]

I'm using Access 2003. I have a report that allows the user to
retrieve data from a certain time period. For example when the report
is run the query asks them to enter a start date and enter and end
date. Is there a way to get the dates the user enters printed on the
report? Thanks, Joe

 

[Brendan Reynolds]

=[ParameterHere] as the control source of a text box on the report, where
"[ParameterHere]" is excatly the same as what appears in the criteria row of
the query.

--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com

The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.

 

[Allen Browne]

Add a text box to your report, and in the ControlSource use an equal sign
and exactly the same name as the parameter, e.g.:
=[enter a start date]

For an alternate approach using a form to enter the 2 dates, see:
Limiting a report to a Date Range
at:
http://members.iinet.net.au/~allenbrowne/casu-08.html

 

[Joe D]

Thanks for the response, but I must be doing something wrong it's not
working. Here's what's in the query criteria:
Between [Enter Start Date xx/xx/xx] And [Enter End Date xx/xx/xx]
and here's what's in the text box control for the report:
=[Enter Start Date xx/xx/xx] And [Enter End Date xx/xx/xx]

I only get 12/29/1899 back on my report. I have the text box formated
as short date. Any suggestions?

 

[Brendan Reynolds]

Those are two parameters, not one. You'll need to refer to them separately
....

=[Enter Start Date xx/xx/xx] & " And " & [Enter End Date xx/xx/xx]

Alternatively, it might be easier to use two text boxes, with control
sources "=[Enter Start Date xx/xx/xx]" and "=[Enter End Date xx/xx/xx]",
respectively, and put the 'And' into a label between them.

--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com

The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.

 

[Joe D]

Awesome, works great...you guys are the best