I have a table with about 3200 records at anytime of the month. There are three columns I look at, StoreNum, Dept and Sales. I would like to know which Dept that is in the same store had higher sales. Ex. for StoreNum123, Dept_B would win, so I need a field to return 'highest' or 'lowest' per StoreNum. I can do a Totals/Sum but not sure how I could identify the Dept w/the highest sales that is within the same store.