Change a crosstab column heading

[soron]

Hello,

I need to change the crosstab column Total Of ContractID: [ContractID] into Total Number of Lessons. All the tutorials I find show how to change the heading using an IIf into two different headers. All I need to do is just change one, would I still use the IIf function or zoom and how do I go about doing this?

 

[vbaInet]

So tell us what the current headings are at the moment.
Plus, give us a list of records so we know what the output looks like currently.

Then finally, tell us how you would like the headings to appear.

 

[NZArchie]

If you are just changing that heading you can just change it in design view, from:

Total Of ContractID: [ContractID]

to

Total Number of Lessons: [ContractID]

Is that what you were asking?

 

[vbaInet]

If you are just changing that heading you can just change it in design view, from:

Total Of ContractID: [ContractID]

to

Total Number of Lessons: [ContractID]

Is that what you were asking?

That would just be too obvious, but you could be right