Precisely something like that. I would love to stand corrected, but as far as my knowledge goes, you cannot combine an alter table query with an insert query in MS-Access (at least till Office 2010)