I have 4 fields on a report. [Field1], [Field2],[Field3], and {Field4}. I also have two fee fields. [Fee1], and [Fee2]. I need some logic to state that if Field1, 2, and 3 are all 0, then add [Fee1]. If either field 1,2,or 3 have any value other then 0, add [Fee2]. The point is that on a transaction that only has a value in [Field4] charge one fee [Fee1], any other combination of the 4, charge another fee [Fee2].
Any suggestions?
Any suggestions?
