Error message in date headers on reports

Lynn73

Registered User.
Local time
Today, 10:04
Joined
Jun 6, 2007
Messages
25
Can anyone help?
I have set up some reports based on queries using access 2003.
I have a form which prompts the user for a start and end date which is the criteria that is used to run the report. At the top of the output report I have set up a text box to show the dates that the user entered, however, if the user enters date where there is nothing to report the text box show #Error

Text box text:
=""&[forms!frm_report_parameters!cbostartdate] & "to " & [forms!frm_report_parameters!cboenddate]

Text in query:
>=[forms]![frm_report_parameters]![cbostartdate] and <=[forms]![frm_report_parameters]![cboenddate] & " " &#23:59:59#

Thanks
 
First of all why the extra "" at the beginning, plus your bracketing is off:

=[forms]![frm_report_parameters]![cbostartdate] & " to " & [forms]![frm_report_parameters]![cboenddate]
 

Users who are viewing this thread

Back
Top Bottom