Renaming Column Headers in Pivot Table

[excellenthelp]

Hello Accessors!



I am in the process of developing a pivot table with grouping per month per year which works just fine. However, I would like to rename the column header items. It will not allow me.

The scenario:
the data is from a query that deprives data from two tables (Date from Table A) and (TypeID from Table B: Query will show TypeID in text format based on SELECT to show data in text format not numeric format).

The struggle:
Renaming the column headers which shows the TypeID in numbers based on its ID (the first column of Table B), not its Description (the second column of the Table B).

The question:
How do I make the column headers to show the TypeID in text based on its Description in the second column of the Table B?

Thanks!

[June7]

You are doing CROSSTAB query? Column headers are derived from data.

Need to include the related tables by joining in query so the associated info will be available. Then use the descriptive fields for the CROSSTAB ColumnHeader criteria.