Printing parameters on reports

  • Thread starter Thread starter jcdifi26
  • Start date Start date
J

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
 
=[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.
 
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?
 
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.
 
Back
Top