Update Query Question on a Number Field

[Rhonda Floyd]

I'm running an update query that's updating a number field (double). The 'Update to' value is .98, after the update is finished I look at the updated table and the value is .97 Unfixed the value is .97967

I changed the update query field format to fixed and it still comes out the same.

I checked the query and most of the values are rounding up correctly? I'm updating 233 records and only 36 records are incorrect each one by 1 cent.

Any help will be greatly appreciated.

Thanks.

 

[LeAnne]

You said "cent"...Is the Format property of the Number(Double) field set
to Currency?

hth,

LeAnne


************

I'm running an update query that's updating a number field (double). The
'Update to' value is .98, after the update is finished I look
at the updated table and the value is .97 Unfixed the value is .97967

I changed the update query field format to fixed and it still comes out
the same.

I checked the query and most of the values are rounding up correctly?
I'm updating 233 records and only 36 records are incorrect
each one by 1 cent.

Any help will be greatly appreciated.

Thanks.

 

[Rhonda Floyd]

It's set to Fixed - I changed it to Currency, and it still didn't work
Thanks,
Rhonda

You said "cent"...Is the Format property of the Number(Double) field set
to Currency?

hth,

LeAnne


************

I'm running an update query that's updating a number field (double). The
'Update to' value is .98, after the update is finished I look
at the updated table and the value is .97 Unfixed the value is .97967

I changed the update query field format to fixed and it still comes out
the same.

I checked the query and most of the values are rounding up correctly?
I'm updating 233 records and only 36 records are incorrect
each one by 1 cent.

Any help will be greatly appreciated.

Thanks.

 

[LeAnne]

Which version of Access are you using? If it's a recent version, you may
be able to use the ROUND() function in your Update query. With older
versions (e.g. A97), you may have "coerce" your query into formatting
the updated value as Currency using CCur(). Could you post the SQL of
your query?

LeAnne

 

[LeAnne]

PS. To how many decimal places is your currency field set? If it's
"Auto," then Access' default setting for a Currency field type is 4
decimal places. Try resetting it to 2.

L.