B bsdixon Registered User. Local time Today, 07:44 Joined Nov 13, 2003 Messages 62 May 23, 2004 #1 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
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
P Pat Hartman Super Moderator Staff member Local time Today, 02:44 Joined Feb 19, 2002 Messages 47,209 May 23, 2004 #2 You can use the Nz() function. =Nz(your expression)