how do I enter a value to an entire pre-existing column?

R

Richard

I have a database with over 300 names and addresses. How do I add another
column (for donated money) that will automaticly show a value of 0 in all
fields of the new column?
 
A

Allen Browne

Use an update query:

1. Create a query into this table.

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

3. Drag the new field into the grid.
In the Update row under this field, enter:
0

4. Run the query.
 
Top