Populate a new field in an existing table

[Jim]

I want to add a date field to an existing table and populate all records with
a single date.

 

[John Spencer]

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
'====================================================

 

[Jim]

Thank you John! It worked great.

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
'====================================================