data type mismatch error in criteria expression-ms access -

i using following query:

select containers.salesordernumber,     getweightinmt(sum([netweight]), weightuom) expr1,     cint(round(getweightinmt(sum([netweight]), weightuom), 0)) wtmt,     salesorders.customerid,     salesorders.salesorderid,     salesorders.unitprice,     salesorders.quantity,     salesorders.salescommission,     salesorders.latestshipdate,     salesorders.portofdischarge,     salesorders.placeofdelivery,     salesorders.lowertolerancepct,     salesorders.uppertolerancepct,     salesorders.grade,     (salesorders.quantity - wtmt) openqty containers inner join salesorders on containers.salesordernumber = salesorders.salesordernumber group containers.salesordernumber,     containers.weightuom,     salesorders.customerid,     salesorders.salesorderid,     salesorders.unitprice,     salesorders.quantity,     salesorders.salescommission,     salesorders.latestshipdate,     salesorders.portofdischarge,     salesorders.placeofdelivery,     salesorders.lowertolerancepct,     salesorders.uppertolerancepct,     salesorders.grade; 

and calculate sum of "openqty" in textbox. error "data type mismatch in criteria expression". please help. thankyou

you cannot use calculated field (in case wtmt) part of calculation of field. have re-use entire calculation.

(salesorders.quantity - wtmt) openqty 

to

(salesorders.quantity - cint(round(getweightinmt(sum([netweight]), weightuom), 0))) openqty 

that may not problem. recommend running our query 1 calculated field @ time see 1 gives error.