B bsdixon Registered User. Local time Today, 14:19 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, 09:19 Joined Feb 19, 2002 Messages 47,225 May 23, 2004 #2 You can use the Nz() function. =Nz(your expression)