locked
Customers that havent ordered in 18 Mo RRS feed

  • Question

  • I have a table of customer Order and Sales information. I want to identify customers that have not ordered in 18 months. The fields in the table are:

    Customer ID, Customer Name, Invoice #, Sales Date, Sales Amount, Order Date, Order Number, Purchase Order Number

    For any record where the Sales Date occurs in September 2015, I want to evaluate the table to determine if the ordering customer, using Customer ID,  had a sale between March 1st 2014 - Aug 31st 2015.  If there is no sale within that time frame I would like a value in a new field = "New in Sept 2015"

    For any record where the Sales Date occurs in October 2015, I want to evaluate the table to determine if the ordering customer, using Customer ID,  had a sale between April 1st 2014 - Sept 30st 2015.  If there is no sale within that time frame I would like a value in a new field = "New in Oct 2015"

    Monday, December 14, 2015 10:48 PM

Answers