Susan Harkins
ssharkins at bellsouth.net
Sat Apr 17 15:57:21 CDT 2004
You don't need a querydef, you can stick a SQL UPDATE in a For Mext loop. Susan H. 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 -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com