Default Values

A

Andy Roberts

I want to add a field to an existing table which has a default value. The
table already has thousands of records and the default only gets applied to
new records. How do I automatically apply the default value to all existing
records?

--
Regards

Andy
___________
Andy Roberts
Win XP Pro
Access 2007
 
M

Mark

You can use an update query and update the new field in all existing records
to the desired value.

Steve
 
A

Andy Roberts

Mark

Perfect. All done. Thanks

--
Regards

Andy
___________
Andy Roberts
Win XP Pro
Access 2007
 

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

Adjusting the layout of over 1000 existing Word documents using a macro-driven batch run 0
Autonumber field in Excel that behaves the same as Access 0
Summaries based on criteria 9
Count Text Values 2
Rules to Save Attatchments 1
How do I clear a form? 0
fill each record with same field entry after records already exist 0
Default Value =now() in table 2

Top