null value

  • Thread starter Thread starter Delf
  • Start date Start date
D

Delf

in my report I have 2 fields with amount in them and if
this amount is equal to zero I don't want it to show on
the report. I do I do that?
Tx
 
I would calculate the result in my query upon which the form is based.
Something like...

NewValue: [Field1] + [Field2]


Then, in the criteria for that new field, put <>0


Rick B
 
Back
Top