Cumulative Sum in a Crosstab Query

[SusieQin]

It's been a very long time since I've posted and I'm hoping for some SIMPLE answers.

I am no master and I've NEVER dealt with cross tab queries or DSUM attributes.

Here's there SQL:

TRANSFORM Sum([QRYLSD Dock Landing Ships MRS Data Query2].[Sum Of CSMP_LEDGER_TOTAL_COST_AMT]) AS [SumOfSum Of CSMP_LEDGER_TOTAL_COST_AMT1]
SELECT [QRYLSD Dock Landing Ships MRS Data Query2].HULL, [QRYLSD Dock Landing Ships MRS Data Query2].MAJ_SWLIN, Sum([QRYLSD Dock Landing Ships MRS Data Query2].[Sum Of CSMP_LEDGER_TOTAL_COST_AMT]) AS [SumOfSum Of CSMP_LEDGER_TOTAL_COST_AMT]
FROM [QRYLSD Dock Landing Ships MRS Data Query2]
WHERE ((([QRYLSD Dock Landing Ships MRS Data Query2].HULL)="LSD 0041"))
GROUP BY [QRYLSD Dock Landing Ships MRS Data Query2].HULL, [QRYLSD Dock Landing Ships MRS Data Query2].MAJ_SWLIN
PIVOT [QRYLSD Dock Landing Ships MRS Data Query2].FY;


My boss is very please with this. He loves pivot tables, but now he wants to see a cumulative amount seen each year in accordance to it's SWLIN. The Totals, wasn't enough.

So how to get SWLIN 0XXXX to go 2000 amount + 2001 = in 2001 + 2002= in 2002

I hope that makes sense. If need be I'll post a dummy report. Please help... Without confusing me. I've gotta be able to produce thise ASAP.

Thank you!!!

 

[JHB]

Yes post a "dummy" database with the report in it + some sample data and also a "picture" of how you want the report should look like.

 

[SusieQin]

I'll get working on that. I have to "change" information due to high sensitivity. I'll have it up by tomorrow. Thank you!

 

[JHB]

Okay - I'll wait for that.