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

Ken,

You have been in my SIG long enough to know that is a resounding YES, it is 
a bad design.  But, do you actually populate all 140 tables with the same 
data like she is doing?

Robert

At 03:42 PM 4/19/2004 -0500, you wrote:
>Date: Mon, 19 Apr 2004 12:19:09 -0500
>From: "Ken Ismert" <KIsmert at TexasSystems.com>
>Subject: RE: [AccessD] Re: Changing the table in a query so I can
>         loopthrough     thequery
>To: "'Access Developers discussion and problem solving'"
>         <accessd at databaseadvisors.com>
>Message-ID: <005401c42632$6d9702d0$2a3ca8c0 at TEXASSYSTEMS.COM>
>Content-Type: text/plain;       charset="us-ascii"
>
>
>Well, I've been shepherding a db with almost 140 identical tables. Maybe
>twice the design problem? I inherited it three years ago, and it soon became
>clear that the cost to redo it 'properly' was too high. Perhaps in another
>three years the opportunity will present itself.
>
>-Ken