OK, I hope that I can make this clear... I just started with Access and this is my first posting here :)
[Table1] has fields [t1ID], [text1], [text2] and [bool] containing records {{1;Jane;Smith;0}; {2;John;Davis;-1}; {3;Bob;Jones;-1}; {4;Al;Brown;0}}
[Query1] reads "SELECT t1ID, [text2] & "...