Column groupings in a report

[BrotherBook]

Hi-

I am running into some issues when trying to create a summary report. I have a table called PipelineDB which contains sales leads. I am trying to create a report that will have three fields for different groupings.

Attached is an excel file of the template i'd like to create. I am able to use a crosstab query to get this just using one value, but i'd like to have all three (commitment, new bus rev, and fees).

Is this possible?

Thanks-

Mike

 

[plog]

Not with just access it isn't--a cross tab query won't allow multiple column headings. A pivot table however will. My suggestion is to spit out the necessary data from access, paste it into excel then pivot off of that data in excel to get the format you desire.

 

[BrotherBook]

Ok, it had started to seem that way. I think i might have an excel file with a pivot linked up to my Access table and use GetPivotData to pull what I need into a formatted table.