I have a spreadsheet of a few thousand lines of order data of order # and SKUs Ordered which I imported into Access. Now I need analyze the data to figure out which two SKUs are most commonly sold together (i.e. same order).
Is there a way I can automatically do this? Or do I have to write some VBA?
I have tried setting up relationships and making queries and reports based on the data but I just cant figure it out.
I know this can be done VBA but I need a fast and automated way of doing this, after all, this is the type of thing access is made for, right?
Heres a screenshot of what my data looks like: The first column is Order, second column is SKU ordered.
Any help is appreciated! Thank you!