Re: Modifing Cells- Increasing numbers in a table

message from Allen Browne on 22 May 2004
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.
 

Archived message: Re: Modifing Cells- Increasing numbers in a table (MS Access)
 
Note: To make this discussion more readable on the page the original messages have been edited to remove most of the references and quoting.