Crosstab Queries-column headings

K

katie

I am creating a crosstab query with plant codes and
planner names. I was able to create it with the plant
codes as the column headings. The problem occurs when I
try to use the planner names as the column headings. The
names come out as numbers. I want the names as column
headings because i am using the info in a report and i
have so many plant codes it does not fit on one page.

Please let me know if you have any ideas as to where hte
problem may be!
Thanks
 
M

Michel Walsh

Hi,


You have ill formed name, so, you have to use the syntax [3], as example, that mean the field with
the name 3, rather than the number 3 itself.


Hoping it may help,
Vanderghast, Access MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

CrossTab Combining 2 fields into Column heading 1
Crosstab column data count 6
crosstab query column heading 2
Help on crosstab query 2
Merge excel files with different column headings 1
Column headings in a crosstab query 1
update crosstab 0
Crosstab By Date (Month) 5

Top