I have 3 tables Invoices,details & Clients. I have a query that gives me a list of dates, invoices & amounts spent during a given period. I want to have the query give me a list of the total amount spent by each client during this period. Each client has several invoices
I could specify each client in the criteria and then sum up each invoice amount to give me what I want but with a 100 clients this seems awfully longwinded.¿Is there a way I can print one query to list what each client spent during a given period.
I could specify each client in the criteria and then sum up each invoice amount to give me what I want but with a 100 clients this seems awfully longwinded.¿Is there a way I can print one query to list what each client spent during a given period.