No Data Returned - Would like that written on the Report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a report that the user can enter date parameters (Start Date and End
Date) works great unless there is no data for the days entered and then on
the report it has #Error.

I would like the dates to still populate on the report and on the report
have written "No Data entered for the week". This would be much nicer and
cleaner when I have to give it to my boss.

Help is very much appreciated!!

Thanks, Stacey

P.S. This report is based on a query in case I need to do something in there
instead.
 
You can't get parameter prompt values to appear in a report when no records
are returned. If your criteria was pulled from controls on a form, you could
use a control source like:
=IIf([hasdata],"Data for the week beginning: " &
Forms!frmDates!txtStartDate, "No data for the week beginning: " &
Forms!frmDates!txtStartDate)

Try to move away from using parameter prompts since they are prone to user
entry errors, are not flexible, and are limiting.
 
Back
Top