Increase fields 6%

[Jason Frazer]

I have a table "Reagents" I would like to increase all
values in fields "OZ2", "OZ4", and "OZ8" 6% and replace
the existing value with the new value for all records.

Thanks for your time and help

Jason

 

[Duane Hookom]

Your field names suggest you might be "Committing Spreadsheet". However, you
should be able to use an update query.
Update Reagents
SET [OZ2] = [OZ2] * 1.06,
[OZ4] = [OZ4] * 1.06,
[OZ8] = [OZ8] * 1.06;

Make sure you back up your MDB prior to running any mass update queries.