Create Table with Default Value

Question

I have a Make Table query that works. I want to set a couple of default values in the Create Table SQL. I don't know the syntax for what I want to do. How do I?:

• Set default value to a fixed string (i.e., City TEXT ... "San Francisco")
• Set default value to a value in a table (i.e. CityID Number ... tblVar.CityID)

Thanks!!!

Answer 1

The data in this table is not accessed directly by any users. It is appended from records in another table and the user never gets to touch it. I'm trying to have it get its default value based on the userID of the person who clicked the button to do the import/append. I guess I'll have to write some code to update the table with this information after the fact.

Thanks for the info Bob.