Column headings in a crosstab query

[Kath]

Hi,

I had tried to do the following in order to rename the column headings in a
crosstab query:

1. Go into the DESIGN view of the crosstab query

2. Right click on the field name

3. Select Properties

4. In the COLUMN HEADINGS section, enter each desired column heading in the
order in which I want them to be displayed and separate the headings with
commas

5. Close Query Properties box

6. Run query

I got an error message, stating this: Data type mismatch in criteria
expression

Note: When I run the query with the default column headings, I do not get
the error message.

What did I do wrong?

Thanks!

 

[Duane Hookom]

You can't "rename" the column headings. You can specify the names of the
column headings which should match the exact values in your column heading
field.

Share your SQL view if you need more answers.