Sum Calculated Field Question

  • Thread starter Thread starter Caravatis
  • Start date Start date
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?
 
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?
Click to expand...

Some field somewhere is a Long Integer (the default Number datatype); Integers
are by definition whole numbers. Check the query, and (probably more to the
point) check the datatypes of the fields upon which the query is based.

Feel free to post the SQL view of the query if you need help.
 
Back
Top