I have tried several methods to solve the following but still no joy......
Basically what I am trying to do is calculate the percentage of customers who return and purchase (repeat custom).
I have a customer Table with a unique Customer_ID and a seperate order table which has the RID of Customer_ID. What I am trying to do is calculate how many customers have made more than one purchase and compare this to the number of customers to get a percentage figure?
Any ideas how I can run a query on the order table to find out where a customer_ID occurs more than once?