Date: Sep 19, 2008 09:26
... the number of customers that ordered once, number of customers that have ordered 2 times and so on. This works fine for 1 affiliate. But now, to get a global view, I want it done for all affiliates. You should think that the first query would look like this: strSQLNoOfTimesOrdered = "SELECT [AffID], [CustID], Count([CustID]) AS [NoOfTimesOrdered] " & _...