Solved: Crosstab with date intervals

[philfer]

Hello,

Im quite stuck.

I have data which has :-

1) Account code
2) Amount
3) Maturity date

And I am trying to create a crosstab query that will analyse the data into time intervals so it ends up like :-


Account <3 months >3 months<=6 Months >6 Months<=1 Year
12345 100
23456 100
34567 100
56789 200

And I am getting myself into quite a muddle as to how to go about it

Can anyone offer any advice

Thanks
Phil

[OBP]

Sory, I can't see what you are trying to do, are you trying to Plot each Quarter total, if YES then use the Combo Wizard's Date = qtr function.

[austenr]

OBP is right.