Default Values

[beccy]

I've not had too much experience of Access so if this a simple query I apologise! I have imported a CSV file as a new table, but would like to add a new column with a default value of Y... I would like the Y to be inserted for all records, not just new ones, how can I do this?

Thanks in advance for any help

 

[Norie]

Add your new field then create an update query that sets the value to Y for that field for all the records.

The SQL would look something like this.

UPDATE MyTable SET MyTable.NewField = "Y";