To start with, I've never worked with Access before so I need help.
I have four tables that have similar information. The first table contains a list of all possible customer names. The next three tables contain sales data for individual years. These tables contain the customer name and a transaction amount. There is a row of data for each transaction the customer made in a year. Not every customer in the first table will appear in the other tables. So as an example, the individual tables for years will look like:
Adam 50.00
Adam 75.00
Adam 42.32
Bob 12.00
Dave 15.00
Dave 25.00
But the first table with all customer names will look like:
Adam
Bob
Chris
Dave
I need to have Access look to the four tables and output a table or report (something I can print) that will show all of the customer names from the first table with with sales totals for the years from the other tables. Like this:
Customer Name 2012 Sales 2013 Sales 2014 Sales
Adam 167.32 225.00 300.00
Bob 12.00 0.00 0.00
Dave 40.00 10.00 0.00
Can someone tell me how to do this?
Thanks
Dennis