Populate a new field in an existing table

J

Jim

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

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

Jim

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...
 
Top