#error

bsdixon

Registered User.
Local time
Today, 00:20
Joined
Nov 13, 2003
Messages
62
I have a calculated field in a report. The value shows up in the report as #Error until I enter the values in the other cells for the calculation. Is there any was to prevent this #Error message to show up?

Thanks
 
You can use the Nz() function.

=Nz(your expression)
 

Users who are viewing this thread

Back
Top Bottom