Sum fields from column heading in crosstab query

[rlmax]

I have a crosstab query set up with Month as row headings, Pool (or grouping) as column headings and the sum of balances as values. There are 6 "Pool" values: 0 through 5. I am trying to sum only pools 3, 4 and 5. Here is my query:

TRANSFORM Sum(delFebruary.Balance) AS SumOfBalance
SELECT Format([BookingDate],"mm-yyyy") AS Month
FROM delFebruary RIGHT JOIN Originations ON delFebruary.[Member#] = Originations.MemberNumber


GROUP BY Format([BookingDate],"mm-yyyy")
ORDER BY Format([BookingDate],"mm-yyyy")
PIVOT delFebruary.[Del Pool];

I can add criteria to [Del Pool] but that only filters out the columns I don't want to see.

I also tried DSum, but I couldn't get that to work either. I tried DSum("Balances","delFebruary","[Del Pool] > 2"") which returned the same number for every row and column.

Any thoughts?

[CJ_London]

try

pools3to5:sum(iif([del pool] in (3,4,5),Balance,0))

or

pools3to5:sum(iif([del pool] between 3 and 5,Balance,0))

or

pools3to5:sum(iif([del pool] >=3 and [del pool]<=5,Balance,0))

[rlmax]

All three of those worked. You are my hero!