Update/Make Table Formatting

[Brandon]

Having some problems here... Trying to use either an
update query to correct some records in a table. When I
run the query as a Select query, the value returned to me
is in the correct format, currency, such as $52.69. When
I attempt to run the same query as an update query, Access
returns 53. I've tried adjusting the format and decimal
places within the table and the update query, but it just
keeps writing 53. How to I get Access to return the
correct format using an update query?


Thanks,
-Brandon-

 

[John Spencer (MVP)]

What is the field type you are attempting to put the value into. Is it numeric
field with a field size of Long Integer or Integer? If so, then Access is
converting the value to an integer so it can be stored. Try changing the field
from Number to Currency.

 

[Van T. Dinh]

Please post relevant Table details, the SQL Strings for
the Select Query and the Update Query.

HTH
Van T. Dinh
MVP (Access)