I have a basic table 4 columns
pay year, customer number, customer name, invoice number
Theres around 20'000 records.
What I want to do is write a query, to show per year how many transactions have gone through per customer number/name. So for example if there were 200 invoices for customer number 10056 then I'd like a summary table like
customer number - customer name - year - total invoices per this customer.
Any ideas how?