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.
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.
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
