C
Caravatis
I have a calculated field in the detail of a subform [Total Price] set to
currency format (this is actually calculated in the query that the form gets
its controll from) . In the footer I have a text box that calculates the sum
of the records in the detail section using =Sum([Total Price]). My Problem
is that my sum field (also set as currency) keeps rounding the total down to
the closest whole number (but still displays in the $10.00 format). There is
no extra code anywhere that is rounding this number down....any suggestions?
currency format (this is actually calculated in the query that the form gets
its controll from) . In the footer I have a text box that calculates the sum
of the records in the detail section using =Sum([Total Price]). My Problem
is that my sum field (also set as currency) keeps rounding the total down to
the closest whole number (but still displays in the $10.00 format). There is
no extra code anywhere that is rounding this number down....any suggestions?