Parameter Value as a Report Heading (Label/Text)

  • Thread starter Thread starter Sarah G
  • Start date Start date
S

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
 
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 ;-)
 
Back
Top