How to create product families in access

[lex231]

Hello,


I am trying to group together different product id's with the same sales order number in access. The output I am looking for would show how many times the product id's would show up on the same sales order. I don't have much access experience so I am kind of stuck on how to build the query. The following picture is an example I did manually of the output I am looking for. Any help would be great!!!

Thanks!!

[ranman256]

the grid makes no sense.
Its product vs itself. A single line will do this : ProdID, Count.
Unless you meant SalesOrder vs Product.

[orange]

lex,

I have a feeling you have excel experience.
If you want to know about Products on sales Orders, I think your basic table structure may be incorrect.

Consider:

A Customer buys something(s) via 1 or many SalesOrder
A SalesOrder may contain 1 or Many Items. This is typically handled by a SalesOrderDetails table
An Item or Product information is stored in the Product table.

Customer---->SalesOrder-->SalesOrderDetails<---Product

This structure handles:

Customer Bob makes 2 SalesOrders during 2016
On his first SalesOrder he purchased 10 of Product #3 @ $20.00 each and
i 4 of Product #123 @ $4.59 each

On his second SalesOrder he purchased 11 of Product #200 @ $6.88 each

Hope this is helpful. Good luck.