Can't get this SUM-ing right

[Jenay]

Table Looks Like This:
[Cust],[Days],[Amount]
abc, 30, 10.00
abc, 25, 25.00
abc, 20, 7.00
def, 20, 8.00
def, 30, 9.00
xyz, 30, 25.00
xyz, 25, 10.00

And I want it to query to this:
[Cust],[DaysLessEqual20],[DaysOver20],[Total]
abc, 7.00, 35.00, 42.00
def, 8.00, 9.00, 17.00
xyz, 0.00,35.00, 35.00

But it's just not comming out right

 

[Pat Hartman]

Select Cust, Sum(IIf(Days <= 20, Days, 0)) As DaysLessEqual20, Sum(IIf(Days > 20, Days,0) As DaysOver20, Sum(Days) As Total
From YourTable
Group By Cust;

 

[DALeffler]

I think Pat meant:

Select Cust, Sum(IIf(Days <= 20, Amount, 0)) As DaysLessEqual20, Sum(IIf(Days > 20, Amount,0)) As DaysOver20, Sum(Amount) As Total
From YourTable
Group By Cust;

 

[Jenay]

Thanks... it works... now if I can apply what I learned ...