There are three fields involved in this query...JobNum, BarSize, and BarWgt.
I'm trying to select the BarSize for every JobNum where the BarWgt is max out of all the entries
So far for the Query I have...
...which gives me the max BarWgt for each JobNum, but I'm more interested in the BarSize label and I can't seem to return that.Code:SELECT dbo_tblBars.JobNum, Max(dbo_tblBars.BarWgt) AS MaxOfBarWgt FROM dbo_tblBars GROUP BY dbo_tblBars.JobNum ORDER BY dbo_tblBars.JobNum;