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] & " " :59:59#
Thanks
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] & " " :59:59#
Thanks