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.
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.