A
Ann Scharpf
Is there any way to combine and IIf() with the NZ function so that if the
RESULT of the calculation is zero, I can get a null? I need the NZ() to get
the query to calculate properly when either of my variables is a null. But I
am producing an output that's being used to identify data discrepancies for
over 100 people for 26 pay periods. It would be a lot easier to spot the
errors if the "good" data was just blank space rather than a lot of zeroes.
I'd appreciate any ideas you can give me. Thanks.
RESULT of the calculation is zero, I can get a null? I need the NZ() to get
the query to calculate properly when either of my variables is a null. But I
am producing an output that's being used to identify data discrepancies for
over 100 people for 26 pay periods. It would be a lot easier to spot the
errors if the "good" data was just blank space rather than a lot of zeroes.
I'd appreciate any ideas you can give me. Thanks.