Crosstab Query

[cbearden]

I am having trouble setting up a query.

I have created a query to grab records containing info from 2 tables. The following is what is that query:

curGcost
curGrefund
curSCcost
curSCrefund
curCLcost
curCLrefund
dtmAll

Expressions:
Total Cost: Sum([curGcost]+[curSCcost]+[curCLcost])
'this calculates the total Cost
Total Refund: Sum([curGrefund]+[curSCrefund]+[curCLrefund])
'this calculates the total Refund
Sum([dtmGrec]-[dtmSent])
Sum([dtmSCrec]-[dtmSent])
Sum([dtmCLrec]-[dtmSent])
Sum([dtmOrec]-[dtmSent])
'The following 4 expressions calculates the days between request for refund and received refund. I am trying to get only those records that are >45 days.


I'm trying to get all Gcost, Grefund, SCcost, SCrefund, CLcost, CLrefund each totaled. So I should have 6 different totals. Also, I was trying to get the total for all COST and all REFUND(which the first 2 expressions do.)
I am having trouble setting up a crosstab query. COuld someone help?

Thanks!