Start and End Dates show error

[Guest]

I now have my start and end dates in my report but if there is no data
entered between the start and end date it shows error not the dates how do I
always show the dates even if there is nothing in the detail of the report
thanks

 

[Allen Browne]

Calculated controls typically show #Error when there is no data.

A simple way around that is to cancel the No Data event of the report, so it
doesn't open if there is no data.

Or, you can test the HasData property of the report, using IIf() in your
expression. For example, if the problem control currently thas this in its
ControlSource:
=Sum([Amount])
use:
=IIf([Report].[HasData], Sum([Amount]), Null)