Increase fields 6%

  • Thread starter Thread starter Jason Frazer
  • Start date Start date
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
 
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.
 
Back
Top