AnsweredAssumed Answered

How to count customers with first sale within a certain week

Question asked by med on Jan 25, 2014
Latest reply on Jan 27, 2014 by philmodjunk

Title

How to count customers with first sale within a certain week

Post

     I have a customer table and a sales history table linked by customer code.

     The sales history table contains among other fields The sale date, sale type and of course customer code.

     I would like to count the number of customers or possibly produce a list of those who had their first sale of a certain type occurring between two dates. The type of sale and the two dates will be entered on a layout by the user.

     I have tried many ideas but I failed, can any body help me with a hint.

Outcomes