Populate a new field in an existing table

  • Thread starter Thread starter Jim
  • Start date Start date
J

Jim

I want to add a date field to an existing table and populate all records with
a single date.
 
One time event
Add the field and then use an update query to populate with the whatever
date you want.

UPDATE YourTable
SET TheNewDateField = #2008-01-01#



'====================================================
John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================
 
Thank you John! It worked great.

John Spencer said:
One time event
Add the field and then use an update query to populate with the whatever
date you want.

UPDATE YourTable
SET TheNewDateField = #2008-01-01#



'====================================================
John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================
Click to expand...
 

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

Populate field from data in another table 7
Populating a new field 3
Populate a new field in an existing table 2
General ACCESS information 16
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Auto populating in a table 2
Auto Populate 4
Calculating Fields 3

Back
Top