I am trying to query 5 .mdb files which have their own tables, queries,
reports.  Each DB table covers a product such as snack food, soda, water,
milk, ice cream based on customer purchases.  There are obviously duplicate
customers in each table.  All customers have a unique ID such as DFW123,
FTW123, HOU457 etc.  This ID does appear in all 5 database tables since they
may buy all products.

I need to get a query to provide this for each :
CustomerID, StoreName, Address, City, Zip, Snack Food, Soda, Water, Milk, IC

(the above would be the columns)

CustomerID, StoreName, Address, City, Zip, Snack Food, Soda, Water, Milk, IC
DFW123        My Grocery  4567 S   Dal  75         100        239     156    
65    249
FTW123        Ziggy's         346 N    Ftw 76          239        45      
100   78     133

So basically, each Customer ID would show their total purchases of each
product from 5 different tables.  I thought a Union All Query would work, but
what I end up with is 1 column that sums the numbers rather than list them
out under individual columns as above.