Search results
-
L
Qry to group & Sum all data but only returning the location of where Max Pts was
I have 1 table with multi Text columns (location, coaches,ssn etc), and multiple Num columns (pts and product counts) I need to sum all the unit counts & points for each person, but only bring back the location for each person that had the 'max' sales (pts). ex. ssn xxxxxx has 3 sales...