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

Susan,

If you have 71 identical tables, you have a design problem.  Why do you 
need 71 tables with the same information?

Robert

At 12:00 PM 4/18/2004 -0500, you wrote:
>Date: Sat, 17 Apr 2004 16:59:29 -0400
>From: "Susan Harkins" <ssharkins at bellsouth.net>
>Subject: RE: [AccessD] Changing the table in a query so I can loop
>         through thequery
>To: "'Access Developers discussion and problem solving'"
>         <accessd at databaseadvisors.com>
>Message-ID:
>         <20040417205929.PLEB1773.imf19aec.mail.bellsouth.net at SUSANONE>
>Content-Type: text/plain;       charset="US-ASCII"
>
>I'm sorry, not an UPDATE, but a SQL INSERT INTO
>
>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.