I know how to insert values into a table and I know how to insert the results of a select statement into a table.
But is it possible to combine these two methode in MS Access?
Something like this???
INSERT INTO Group (groupID, memberID )
VALUES("1234",(SELECT memberID FROM members WHERE membergroup = '1234'))
Many thanks