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

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

-----Original Message-----
From: Robert L. Stewart [mailto:rl_stewart at highstream.net]
Sent: Monday, April 19, 2004 8:20 AM
To: accessd at databaseadvisors.com
Subject: [AccessD] Re: Changing the table in a query so I can
loopthrough thequery


Susan,

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

Robert