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

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




More information about the AccessD mailing list