grouping and counting

[boutwater]

Hello, I have a table that has an ID, customer, Date, OrderNum, and partSKU. I would like to report on how many times sku x is in the same order as sku y for each sku in the table. I'm not sure how to do this. An order could just be one line (so the above request would not be evaluated), or an order could be multiple lines. Please let me know if you need more info to answer. Thanks,



Ben

[June7]

The criteria for record selection would be:
partSKU="x" And partSKU = "y"

Then construct a field with expression:
SKUx: IIF(partSKU="x", 1, 0)

Now use this query as the RecordSource for a report and you can show detail records as well as Sum total of the SKUx field.

[boutwater]

The partSKU isn't literally "x" ad "y", but could be any value. The table I'm working with has 2 million records, so I wouldn't want to figure out what each possible SKU is and do this manually. Maybe I'm reading your answer incorrectly, but I would want to know how to tell all the unique pairs of SKU's and then from there how to get the number of orders these unique pairs show up in.

[June7]

I thought you were interested in only two particular values. I have no idea how to approach your requirement.