Rounding in Update Query

  • Thread starter Thread starter Betty
  • Start date Start date
Betty,

The first secret is to provide more details when asking for technical help.

Where and how are you "updating" your data?
 
In addition to what Steve mentioned, what's the data type and field type of
the field in which you're trying to store the value. If the data type is
Number, make sure that the field type is one that can accept decimal values.
 
Sorry. I am using an update query to update a currency format field with a
currency format field. I have a "claims" table and a "claims detail" table.
I need to update the claim total from the sum of the details for each claim.
Thank you for your patience.
 
Sorry. I am using an update query to update a currency format field with a
currency format field. I have a "claims" table and a "claims detail" table.
I need to update the claim total from the sum of the details for each claim.
Thank you for your patience.
Click to expand...

It's confusing. Access uses the term "Currency" in two different contexts -
data types and formats. I suspect that the actual datatype - NOT the format,
which just controls the display, not how the value is stored - is Long
Integer. Even if you put a Format of Currency on a Long Integer number it's
still a Long Integer - which is by definition a whole number.

The solution is to change the datatype. I'd actually suggest using the
Currency datatype (in the table design window, it's one of the options along
with Number, Date/Time, Text and so on). This gives you a huge scaled integer
with four (no more and no fewer) decimal places, and no roundoff error.
 
Back
Top