How can you extract a report or query from a database to display items in a database that were bought together most. To illustrate, the shop sells coffee,tea, cereals and yoghurt. I want to know which items were bought together most and least, ie in a decresing order.
Just a thought...but this kinda sounds like a crosstab report with the items across the top and down the side and a count in the middle.
Chester "Chet" West II
Trust in HIM, not in men!
Click Here to Expand Forum to Full Width