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

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

Populating a new field 3
Auto Populate 4
Populate a new field in an existing table 2
Using variables 2
Calculating Fields 3
Field List not letting me add existing field 7
Creating a "Greater Than Date" criterion 2
Automatically populate field on existing db 2

Top