cross sells

[aftershokk]

I have order #, customer, SKU, and # of SKU's in a file.

I am trying to find any cross sell opportunites.

In other words,

When product X is ordered, 60% of the time product Y is also in the order.
Help!!

I do not know much VB.

 

[dcx693]

You don't need VB for that, you need to write some queries.

 

[aftershokk]

any ideas??

I cannot seem to figure it out?

 

[dcx693]

I've designed these particular queries myself, so I can only throw out some general ideas.

If you're looking for when X is ordered, do a query when it was ordered. If you want to see how often other products were ordered when X was ordered include those columns in the query, and do a total on that column grouped by product.

You do know how to create queries right? If not, please look through the online help or pick up a good Access book.