I am trying to SUM a text field, I think I need to convert text to integer using CAST, I understand that this cannot be done in access, unless you convert to varchar first, I am trying this and it will not work???
"SELECT SUM(CAST(CAST(qtyA AS varchar(40))AS CINT)) AS qtyAcount FROM tbl_order"
Access vba has a wide range of conversion functions which allow you to change virtually any legitimate item to another datatype
these include CINT, CLNG, CSNG,CDBL,CSTR and so on. mind you access also often does a pretty good job of doing the conversion all by itself if you assign a string to a number.. but you don't have that control, nor that granularity that most anal developers want if you do it that way.
if you are converting text to a number you may want to check if its a number first, i forget which but I think its if (is_number(<mystrvariable>))
the cint squizoid suggests you use is in fact part of VBA in access, and it is that function you are using int he SQl statement.
mind you it does beg the question why yu are storing numbers as text