How to count customers with first sale within a certain week
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.