Adding default value to pre-existing table

[frets55]

I am working within a database that I created using a downloaded text file. I
have to add a column to the table that will contain the same value in each
field. Is there a way to add this default value to the preexisting table
without keyboarding it in? Thanks in advance for any help.

 

[Jerry Whittle]

Create a select query on that table and field. Run it and see what it return.

Next change this query into an Update query. Put in the value that you want
into Update To.

If you don't want to overwrite any existing data, just update empty records,
put Is Null in the criteria.

 

[frets55]

THANK YOU!

Create a select query on that table and field. Run it and see what it return.

Next change this query into an Update query. Put in the value that you want
into Update To.

If you don't want to overwrite any existing data, just update empty records,
put Is Null in the criteria.