I am trying to print a report in gridview using Inventory records. Report contains the fields Item #, Pic and Qty on Hand. I am noticing that the results in the "Qty on Hand" field contain only the quantity on hand for "Lot 1". Am I choosing the wrong field? How do I get the total Qty on Hand?

(I can put in the quantity in each lot separately, but I really just need the total Qty on Hand.