I have been asked to modify an existing Crystal Report so that it "only returns multiples". I recreated the report (less the totals line) as a 1st step query in MS Access 16 and am wondering how to go about the 2nd step.
There are two fields that I will ultimately group by; grp1 is 'UPC_Co' and grp2 is 'UPC_SKU', both can have multiple sub-entries, but I am looking to only display those records where UPC_Co has multiple UPC_SKU's under it.
My initial thought was to create a counter field that would populate and reset to 1 at each change of UPC_Co, but I'm not sure how to go about doing it. I tried to google this, but all the hits seemed to be for sequential counters for the entire dataset and that isn't what I'm after.
I DID see a couple of post about how to do it in VBA, but I know virtually nothing on VBA. Anybody have any ideas on how to do this in SQL with Access?
Any help is greatly appreciated! Query is attached for those interested