I have an access form that is pulling a sum from the subreport. I want to show $0.00 for any time the controlsource is null or blank from the subreport. Right now it returns #error whenever ther is no data. I would like to show $0.00 in that case.
I currently have this as the controlsource: =Details.Form![price total]