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

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

Guest

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?
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding default value to pre-existing table 2
Add column with data to an existing table 8
Return a value from one column using an array and a single row 1
ACCESS - how do I apply a IIF = statement without parameter value prompt. The two column comparison is count 1
Excel Reference to text returning "0" value on second column 0
Access2007 weird error (any suggestions) 2
Excel Applying Code to a Column 0
Multiplying two Columns 1

Back
Top