knuckelhead
Technical User
I give up. I have a Qry with a Sum on that totals line for StdQryAct field. I wanted 2 decimals. instead, I get 9 decimals.
The table is a number field, fixed 2.
So i tried the following in order to use the Round function but i still get 9 decimals instead of the desired 2.
I have the word "Expression" on the Totals line:
Std Qty Act: Sum(Round(nz([StdQtyAct]),2))
ideas?
The table is a number field, fixed 2.
So i tried the following in order to use the Round function but i still get 9 decimals instead of the desired 2.
I have the word "Expression" on the Totals line:
Std Qty Act: Sum(Round(nz([StdQtyAct]),2))
ideas?