Modifing Cells

J

Jiffy

Does anyone know how to quickly modify a bunch of cells? I have many mdbs with tables of numbers (ie 236, 273, 456 ...). I would like to: add 300 to all the numbers in column D, add 450 to all the numbers in column E, add 650 to all the numbers in column F and so on.... Are there formulas in Access to automate this task or is my only option to manual edit all the cells?

Thanks in advance
 
F

fredg

Does anyone know how to quickly modify a bunch of cells? I have many mdbs with tables of numbers (ie 236, 273, 456 ...). I would like to: add 300 to all the numbers in column D, add 450 to all the numbers in column E, add 650 to all the numbers in column F and so on.... Are there formulas in Access to automate this task or is my only option to manual edit all the cells?

Thanks in advance
Click to expand...

Access has fields, not cells.
If you would like to know how to quickly modify a field, then I can
help.

You could run an Update query.
Update YourTable Set YourTable.FieldNameA = [FieldNameA] +
300,YourTable.[FieldnameB] = [FieldNameB] + 450,YourTable.[FieldNameC]
= [FieldNameC]+ 650;
 
Top