F
ftwguy
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.
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.