AnsweredAssumed Answered

Simple Sales Commission Report

Question asked by c.wagner1 on Dec 16, 2013
Latest reply on Dec 16, 2013 by c.wagner1


Simple Sales Commission Report


     Hi Guys,
     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:
     Name, ID
     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.