Default Values added to existing records?

M

Miriam White

Once a table has been set-up and data entered, how can you
add a default value to an existing record? The standard
feature will only add the default value to a new record.
 
A

Allen Browne

To enter data into the existing records, use an Update query:
Update on Query menu in query design.
 

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

Append Crosstab Query to Existing Table 0
Autonumber field in Excel that behaves the same as Access 0
Split form 0
Mail Merge skipping records/sending one at a time 0
Microsoft 365 Activations, Users or Devices? 0
Default Values 2
Adding Network Trusted Location on MS O365 Word per Computer Registry Setting 1
Outlook 2016: recent change to add account. No browse for data file. 0

Top