G
Guest
I have created an expression joining 5 tables to give me results so that I
can find a variance. In some cases, the table will have a null value and I
have accounted for that with the Nz expression. An example of my formula
appears below.
Expr1:
Nz([GROSS_PAY],0)-Nz([TAX_WAGES],0)-Nz([WAGE_AMOUNT],0)-Nz([401K-Defered
Comp.DED_AMT],0)-Nz([Section 125.DED_AMT],0)
However a large number of my results end up with 2.82E-06 or other simular
numbers which appear to be a truncated fraction. My tables only contain fixed
numbers with 2 decimal places. Does anyone know how to correct this problem?
can find a variance. In some cases, the table will have a null value and I
have accounted for that with the Nz expression. An example of my formula
appears below.
Expr1:
Nz([GROSS_PAY],0)-Nz([TAX_WAGES],0)-Nz([WAGE_AMOUNT],0)-Nz([401K-Defered
Comp.DED_AMT],0)-Nz([Section 125.DED_AMT],0)
However a large number of my results end up with 2.82E-06 or other simular
numbers which appear to be a truncated fraction. My tables only contain fixed
numbers with 2 decimal places. Does anyone know how to correct this problem?