Need to build an Iif statement based on values coming up 0 to not show.
I have the following control source in a text box:
But there are some values that come up 0.
I want to change this to where if it's 0 - then come up blank even thought it's a numeric field.
I know I can use Iif statement to make this work but having trouble with the syntax:
I used this and get the #error
)) = 0, Null)
How do I change the above to make it work?
Thank you in advance.