Getting Text Boxes to round

[Guest]

In a Query I have a field that is called "ExtendedPrice:
CCur([UnitPrice]*[Quantity])". In my form the text box is also ExtendedPrice
the Format I used was currency which made the money round up. But in my
Chemical Total text box the sum of the chemical will not round or add right.
I have one chemical that the total was $24.38 and the other was $110.63.
Which the sum should of showed $135.01 but instead it showed $135.00.

 

[John W. Vinson]

In a Query I have a field that is called "ExtendedPrice:
CCur([UnitPrice]*[Quantity])". In my form the text box is also ExtendedPrice
the Format I used was currency which made the money round up. But in my
Chemical Total text box the sum of the chemical will not round or add right.
I have one chemical that the total was $24.38 and the other was $110.63.
Which the sum should of showed $135.01 but instead it showed $135.00.

The Format only controls what's *displayed*, not what's stored. I'd suggest
changing the query to round the price:

ExtendedPrice: Round(CCur([UnitPrice]*[Quantity]), 2)


John W. Vinson [MVP]