Crosstab Query

[pollenman]

Hi all

I have a crosstab query which works well however the column headings are numeric how can i get the heading to say what they are i.e

Area Yello Pages |Telephone
London
Glasgow

at present it shows

Area 1 | 9
London
Glasgow

Any ideas

Thanks Terry

 

[THWatson]

Terry
From your post, I assume you want to show this only in your query. If that's the case, do this...

In the column where the current column heading reads 1, right click in the Criteria row to bring up the Properties for that column. Set the Caption to Yellow Pages.

Do the same for the column which currently shows a heading of 9, and set its Caption to Telephone.

Tom

 

[pollenman]

Thanks for your help however it did not work comes up with error "Type Mismatch" any clues

Terry

 

[THWatson]

Terry
Probably I'm not following properly the formation of your Crosstab query.

Tell me the fields that are in your query, and which is your Row Heading, your Column Heading, and your Value heading.

Tom

 

[pollenman]

Hi Tom

Area
Source
CountOfArea = value

Row heading = Area
Column Heading = Source

Cheers Terry

 

[THWatson]

Terry
I'm confused. In your table, from which the Crosstab queryis made, you only have 2 fields? And they are Aea and Source? And the Area is a numberic field, and the Source is a text field?

Clarify, and I'll test further.

Tom

 

[RobertGardiner]

I had a similar problem

In the field on the data the months (field called Period)were 1,2,3 to 12

I needed the Col headings in the crosstab query to be

Period 01, Period 02, Period 03 to Period12

What I did was write a make table query that read all fields of the original table as they were and in the next column I put a formula:
SAP PERIOD:iif( [2003Rev]![Period] <10,&quot;Period0&quot;& [2003Rev]![Period] ,&quot;Period&quot;& [2003Rev]![Period] )

And used SAP Period in the Cross tab rather than Period

In your case it would be New Area:iif(

![field]=1,&quot;Yello&quot;,iif(

![field]=2,&quot;Whatever&quot;, and so on...

Use the field New Area in you crosstab

let me know if this works