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