Pivot Table SQL Statement

[taw]

I have a pivot table on a form working just like I need it to, and I need to include it on a report so I want to make a crosstab query exactly like it so that I don't have all of the label and heading formatting. The problem is that I can't get the crosstab to do what I want. Is it possible to extract the sql statement that is used in the pivot table on the form?

I have attached screen shots of the pivot table and some test data.

Thanks,
Tom

 

[OlcayM]

Hi,
I am sorry for offering something stupid ; use the form in the report ?

 

[taw]

Yes ...

Exactly. I don't want to do that, so I need to duplicate the format of the pivot for the report. It is possible to use a form/subform on a report, but the formatting is not desirable.

Tom