[AccessD] Changing the table in a query so I can loop through the query

I have an append query that can work for 71 tables.  I want to create a for
next loop function that will substitute the table names (they are numbers)
each time it loops.  Can someone help me?  I do not quite have the query def
thing down and I think I need to use it here.  Each table has the same
fields.

 

Susan Klos

Senior Database Analyst

Evaluation and Reporting

Florida Department of Education