I have a table that contains customer ID's, order numbers and part numbers.
I need to identify orders that are identical across customers to make ordering groups of parts easier.
E.g. Cust 1 orders parts 7, 11 and 4 in a batch. How many times has that combination been ordered?
Ideally I see this as creating a field that contains the 3 fields in numerical order separated by a delimiter and then counting across records.
In the attached file I would expect
20,304,1626 2 records
20,304,988,1626 1 record
20,304,1911 2 records
unique-orders.xls
MS-Access-concatenate-across-rec.accdb