Parameter Value as a Report Heading (Label/Text)

[Sarah G]

I have a report which is based on a query which has a parameter in the date
field
eg. Query field - Planned Start Date - Parameter [Start Date]. I need the
value chosen when the report is run, to appear as a text label or heading in
the report. I used a unbound text and entered =[Start Date] but it keeps
coming back with an #Error.
I have previously used ="Between" & " " & [Start Date] & " " & "and" & " " &
[End Date], when the parameter has two values. However this time I only want
the date itself but keep getting the error

Hope you can help

 

[Duane Hookom]

IMO, parameter queries are never a good design interface. Always use
references to controls on forms.

However,
does your query return any records?
Did you spell the parameter correctly?
What is the name of the text box? It can't be a field name.

Again, don't use parameter prompts ;-)