I
Ian
I'm creating a query with expressions to add a bunch of
fields toghether but some of the fields in the expression
of null values -- so the expression returns a null.
I'm afraid if I set the format in the field property to
substitute a zero for null I'll bloat my table. Is there
anyway to make the expressions ignore the null's? If not
I can't seem to find the correct format to force a
decimal number to substitute the 0 for null -- can
someone give me the expression.
For the currency fields I placed $0.00;($0.00)
[Red];$0.00;0.00
fields toghether but some of the fields in the expression
of null values -- so the expression returns a null.
I'm afraid if I set the format in the field property to
substitute a zero for null I'll bloat my table. Is there
anyway to make the expressions ignore the null's? If not
I can't seem to find the correct format to force a
decimal number to substitute the 0 for null -- can
someone give me the expression.
For the currency fields I placed $0.00;($0.00)
[Red];$0.00;0.00