Yes, there are empty values for some lines. In addition, some users put 0 as no value instead of leaving it blank.
I made a trial test with your suggestion by adding one more field (IIf(IsNumeric([Ttlweight]),Ttlweight,0) AS Ttlweight1) next to original field. By comparison, the marked...