Other problems which are hopefully easy:

I'm having are converting 2 numerical fields to strings and concatenating them in the query output IE "chknum1" and "chknum2" are numerical but I need to see something like "110, 111" where 110 is chknum1 and 111 is chknum2

I am adding 2 fields but sometimes one of the fields is empty (null) and when that happens it's returning a null result. IE I'm adding chkAmt and chkAmt2, sometimes there's only 1 check so chkAmt2 never gets touched, leaving it with a null character in it. when the query comes across this it assigns NULL to the output field in the query.