Printing Parameters value into a report

tpeter

Registered User.
Local time
Today, 14:57
Joined
Dec 1, 2006
Messages
36
I have a report named "rptTimeTracking" that is generated from a parameter query named "qryTimeTracking". The report works fine but I would like to have the parameters droped into the Report. This report was created by the chart wizard if that makes any difference. I have tried making an unbound textbox with the code of =Reports![rptTimeTracking]![Enter Start Date], but when I preview the report all I see is Error. This is in Access 2003 format. Any help would be great.
 
You need to reference the object containing the criteria that the query uses.

In the report create a text box and on the Control source your require something like

=Forms!MyForm!MyControlname
 
So if I understand correctly my parameter query pulls infomation from tbltimetracking with a criteria of Between Enter Start Date and Enter End Date. So my reference needs to be Table!tblTimeTracking!Enter Start Date?
 

Users who are viewing this thread

Back
Top Bottom