select *,switch(asofdt=#1/31/02#,no_each,true,no_each*-1) as New_No_Each, (select no_each from tblloantape2 where asofdt=#1/31/02#) as no_each1,(select no_each from tblloantape2 where asofdt=#2/28/02#) as no_each2,no_each1-no_each2 as no_each_subtot
from query10;