Hi
This should be really easy but....
I have a Query (qry1) which returns several fields including MyID (Integer)
At a click of a button I want to create a new table with the fields
- MyIdCopy (copied from qry1)
- SelectFlag (Y/N flag) - default set to zero
I could do the CREATE table to create a table and I can do SELECT... INTO to copy from qry1.
But I don't know how to combine the 2.
Any help appreciated
This should be really easy but....
I have a Query (qry1) which returns several fields including MyID (Integer)
At a click of a button I want to create a new table with the fields
- MyIdCopy (copied from qry1)
- SelectFlag (Y/N flag) - default set to zero
I could do the CREATE table to create a table and I can do SELECT... INTO to copy from qry1.
But I don't know how to combine the 2.
Any help appreciated