Loop Append Query

[JJ]

I am trying to create a code that will go through a table of criteria. It
will run a query for a row, append that query to an output table, and then
move down a row and do the same thing over until there are no rows left.

Example of Criteria_Table:

Fields are - Name : Level : Location

Joe : Level 1 : East
Sam : Level 3 : West
Bob : Level 10 : North


Example of Ouput_Table

Fields are - Name : Level : Location : Position Num (from Query on
Criteria_Table and Position_Table)

Joe : Level 1 : East : 2
Sam : Level 3 : West : 6
Bob : Level 10 : North : 9

Any suggestions would be appreciated. Thanks!

 

[JJ]

Edit Below: (Criteria_Table has a Primary Key of IDs)