INSERT INTO [RFM Test Table] ( [RFM Code], Cust_NO, [Last Order], [Avg Order], [Number of Orders], [First Contact Method] )
SELECT "A1B" AS [RFM Code], [RFM Customers and Orders].Cust_NO, Last([RFM Customers and Orders].[Order Date]) AS [Last Order], Avg([RFM Customers and Orders].Sales) AS [Avg Order], Count([RFM Customers and Orders].[Order Number]) AS [Number of Orders], First([RFM Customers and Orders].[First touch]) AS [First Contact Method]
FROM [RFM Customers and Orders]
GROUP BY "A1B", [RFM Customers and Orders].Cust_NO
HAVING (((Last([RFM Customers and Orders].[Order Date]))>=#6/1/2014# And (Last([RFM Customers and Orders].[Order Date]))<#12/1/2014#) AND ((Avg([RFM Customers and Orders].Sales))<220) AND ((Count([RFM Customers and Orders].[Order Number]))>=16) AND ((First([RFM Customers and Orders].[First touch]))<>"Internet" And (First([RFM Customers and Orders].[First touch]))<>"WEB"));
There would be 7 different date ranges that would be used throughout the 50-70 queries so doing a macro and being able to update the dates would really speed this up