Access Query Development
Posted on 2013-02-06
How do I create an MS Access query which will populate multiple rows in a table based on selecting row from an existing table 'where' the selection criteria is based on the value from an open form.
the SQL pseudo code would be something like:
select * into NewTable
where field value in OldTable = archive_id from a form