allfredeneuman
asked on
Access Query Development
Hi,
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
from OldTable
where field value in OldTable = archive_id from a form
Thanks
AEN
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
from OldTable
where field value in OldTable = archive_id from a form
Thanks
AEN
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I accepted multiple solutions. mbizup got most of the points but I could see myself using Helen_Feddema solution in another scenario.
Thank you
Thank you
Open in new window