By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,955 Members | 1,768 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,955 IT Pros & Developers. It's quick & easy.

Cross Tab Query Column head is primary key autonumber.

P: n/a
Hi,

I have a crosstab query made by a linked table, the row headers are
displayed correctly, but the column headers are showing the SNo
(Autonumber) value instead of the NAME field.

Please help

Cheers

Aug 18 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
You need to add an extra column to your table. In this column you will
add the column name you want for each column the crosstab produces.

Autonum NewCol yourDataColum
1 data1 383
2 data2 549
3 data3 394
...

Then, instead of using the Autonum column as the columnHeader column you
can use the NewCol as the column header column

If you can't add a column to the linked table, then you can create a
local table and add the column there (along with a join column that
would join to the autonum column) and join that table to your linked
table in the crosstab query.

Rich

*** Sent via Developersdex http://www.developersdex.com ***
Aug 18 '06 #2

P: n/a
Super, got it !

Thank you ever so much

Aug 21 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.