Printing Parameter Value on the Report

  • Thread starter Thread starter Anil
  • Start date Start date
A

Anil

I have a query that pulls data based on a input date.
I have created a report based on this query. When I open
the report it prompts("[quarter start date]") me to enter
the Date and displays the result.
I have a textbox in the Report, on which I would like to
display the Parameter Value that I entered.
I tried assigning "[quater start date]" to control source
of the textbox, it works only when there is a
corresponding record for that date.
I would like it to display the date that I entered no
matter what the result is.
Any Suggestions?
thanks
anil
 
Anil,

I couldn't get it to work either. So I created a form
that asked for the date and put a button to start the
report on the same form. You can then insert the
following on your report. My example has both a begining
and ending date. This example is what you would put in a
unbound text box.

="Reported from " & [Forms]![Fm_Reports_Calendar]!
[StartDate] & " to " & [Forms]![Fm_Reports_Calendar]!
[EndDate]

hth

Ivan
 
Back
Top