DB_Queen
New member
- Local time
- Today, 14:42
- Joined
- Sep 20, 2021
- Messages
- 22
I am attempting to create a routine to do the following:
1) Create a temporary table with records that match user entered criteria from a form
2) Insert records into a table that includes some data from this temporary table and some data from an existing employee table
I am reasonably new to VBA. I was able to figure out how to create the temporary table using a Make Table query, but I don't know how to do the next step. There are no associated fields in these two tables, so I can't use a JOIN query or the like.
Any advice or guidance you can provide is greatly appreciated!
1) Create a temporary table with records that match user entered criteria from a form
2) Insert records into a table that includes some data from this temporary table and some data from an existing employee table
I am reasonably new to VBA. I was able to figure out how to create the temporary table using a Make Table query, but I don't know how to do the next step. There are no associated fields in these two tables, so I can't use a JOIN query or the like.
Any advice or guidance you can provide is greatly appreciated!