Modifing Cells- Increasing numbers in a table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Use an Update query:

1. Create a query into your table.

2. Change it to an Update query (Update on Query menu).
Access adds an Update row to the grid.

3. Drag field [D] into the grid, and in the Update row underneath, enter:
[D]+300

4. Run the query.

That adds 300 to D as in your first example. You can update several rows at
once.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Jiffy said:
Does anyone know how to quickly modify a bunch of cells? I have many mdbs
Click to expand...
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?
 
Back
Top