Add New Column in Make Table Query 1

[perrymans]

I have a Make Table query coded into VBA with a RunSQL command to kick it off.

The MakeTable is being formed from three existing tables except...

How can I add a new column called "UseCheck", column type Yes/No, and update all of the records to Yes?

Thanks. Sean.

 

[Remou]

It is easy enough to add an extra column:

Select Field1, Field2, True As newField Into tblTable2 From tblTable

However, it will not be boolean. You can then Alter Table:

Alter Table tblTable2 Alter Column NewField YesNo

 

[perrymans]

Works for me, I figured I'd have to run something after the fact.

Thanks. Sean.