M musicmaker Registered User. Local time Today, 19:29 Joined Jun 29, 2000 Messages 17 Aug 7, 2000 #1 I need to remove the zero when the answer comes back ZERO. I need the field to be blank. Nothing in it. Thanks in advance for your help.
I need to remove the zero when the answer comes back ZERO. I need the field to be blank. Nothing in it. Thanks in advance for your help.
K Karl K Registered User. Local time Today, 19:29 Joined Feb 2, 2000 Messages 41 Aug 7, 2000 #2 Is it a calculated field? Try iif(Sum([Field4) = 0, Null, Sum([field4)) Make sure there is no default of 0 on the form. Also check the table to make sure there is no default of zero on the table.
Is it a calculated field? Try iif(Sum([Field4) = 0, Null, Sum([field4)) Make sure there is no default of 0 on the form. Also check the table to make sure there is no default of zero on the table.