When answer = 0, need to remove 0. How?

musicmaker

Registered User.
Local time
Today, 19:29
Joined
Jun 29, 2000
Messages
17
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.
 
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.
 

Users who are viewing this thread

Back
Top Bottom