Steven. Seriously consider storing all of the givers in one table and then add another field that lists the fund. This will simpify your application immensently.

Table Donators:
Fields: fund, giver, amount, ....

Then your select statements are very simple

SELECT giver ;
 FROM donator ;
 WHERE fund = "United Way" AND ;
       fund = "Homeless Shelter" AND 
...

Then your application can be easily expanded without having to add new tables and do tons of UNION statements.

>This works great. However, the next step is dynamic table names. The way my app is set up, the user can add tables with personalized names. Up to ten tables can be added representing different funds in a bookkeeping environment. The table names are stored as an array in a setup table. How can I use the Select/Union code with variables representing the table names?