Crosstab Queries-column headings

  • Thread starter Thread starter katie
  • Start date Start date
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
 
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
 
Back
Top