Adding default value to pre-existing table

  • Thread starter Thread starter frets55
  • Start date Start date
F

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.
 
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.
 
THANK YOU!

Jerry Whittle said:
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.
Click to expand...
 
Back
Top