Hello,
I have a large dataset of customers who have bought a product from me. What I want to be able to do is map in Access a list of other products that were purchased by customers who also bought the same product as you.
Example, Peter bought an orange, an apple and a banana. Simon comes to the site and buys a banana, so I want to be able to say, other customers who also bought a banana bought an apple and an orange.
Rather than listing every single other product bought though, I want to rank. So of the 200 customers who also bought a banana, 50 of them went on to buy an apple whereas only 5 of them went on to buy an orange. Therefore an apple is a better suggested next purchase.
Any ideas on how to create this within Access?
Thanks for any help