Simple Sales Commission Report
Don't think my brain is working today. Here is the set up. Invoices table is related to the Customers and TrackingNumbers tables.
The relevant fields in customers are:
In Invoices the relevant fields are:
invoice number, sold by, invoice total, and invoice total summary
Tracking Numbers contains the fields:
tracking number, and ship date.
My report needs to list the total sales each customer has made for one particular salesman (sold by field) that has shipped in a particular date range. Then the report needs to have a grand total at the bottom. I can't seem to get this to work. It should be easy.