Populate a new field in an existing table

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jim - 23 Feb 2008 19:21 GMT

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

Reply to this Message

John Spencer - 23 Feb 2008 19:33 GMT

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

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

Reply to this Message

Jim - 24 Feb 2008 00:47 GMT

Thank you John! It worked great.

> One time event
> Add the field and then use an update query to populate with the whatever
[quoted text clipped - 12 lines]
> > I want to add a date field to an existing table and populate all records with
> > a single date.

Reply to this Message