Microsoft Access

[jamesu27]

Hello, I have two tables, one called Customer List that has two columns that
has all my customers name in one and their ID# in the other. I have another
table called Customer Transaction that shows all the customers that have made
a transaction within the week. The first column is the customer name, second
column is customer ID, third column is transaction type and last column is
amount. Each customer ID or name can repeat multiple times within the second
table based on the number of transaction they have for the week.

I'm trying to either generate a report or query that will have all my
customers and their ID based on the table Customer List and sum up the
transaction from the table Customer Transaction. What I've been able to
accomplish is sum up all the transaction based on the table Customer
Transaction but for those customers that had no transaction for the week, I
still want them to show up on my query or report with a blank value, but I
can't get this to work. Any help would be greatly appreciated.

 

[Jeff Boyce]

James

If your second table only has ID, CustomerName (redundant and unnecessary,
by the way), transactiontype and Amount, how do you know WHICH week the
transaction(s) belong to?

Regards

Jeff Boyce
Microsoft Office/Access MVP