Increase fields 6%

J

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
 
D

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.
 
Top