Hi Donald,

If I understand the problem correctly that you have different "for" requirements for your sums

Try:
Select all , sum(iif( [Lexp] ,x,0)), sum(iif( [Lexp] ,y,0)) from Sample

Dan