Filling a column with a default value

[Dan]

I have a database with about 70,000 lines already in it. I have added two
new columns StartDate and EndDate. How can I fill these columns with a
default value like 01/01/2003 for start date. I could not find anything
like "Fill Down" and changing the design to default date only works for new
records.

Any quick solutions?

Dan

 

[Kristyn Wagoner [MSFT]]

Hi Dan -

An update query will probably be the quickest way to update existing
records. Your new records should all default to the value you like if you
set it as you already have in the default section.

If you search help for "Update Query", you will receive instructions on how
to create one if you need help.

Hope that helps!

--
Kristyn Wagoner
Microsoft PSS

Please do not reply directly to this alias. This alias is for newsgroup
purposes only.

This posting is provided "AS IS" with no warranties, and confers no rights.

 

[Dan]

It worked, Thanks

Dan

Hi Dan -

An update query will probably be the quickest way to update existing
records. Your new records should all default to the value you like if you
set it as you already have in the default section.

If you search help for "Update Query", you will receive instructions on how
to create one if you need help.

Hope that helps!

--
Kristyn Wagoner
Microsoft PSS

Please do not reply directly to this alias. This alias is for newsgroup
purposes only.

This posting is provided "AS IS" with no warranties, and confers no rights.