crosstab query column headers do not match data in cells

[Guest]

in my cross tab query, the 2 row headers and rows themselves are all text,
which make up the name of the customer. the column headers are drawn from a
table column where the text is in the following format: ISO9001 4.2 Doc
Requirements (there are roughly 80 different descriptions in the column text
boxes but all have roughly the same format). each customer has a reference
number, which is counted in the cross tab query results, and the results also
show a 'total' number, which is what i want.

the question is, when the results are displayed, the column headers do not
read the column text, "ISO9001 4.2 Doc Requirements" but instead show
different integers, for example the column headers read as 0,2,4, etc,
respectively.

how do i get the crosstab query column headers to be displayed as the column
text of, "ISO9001 4.2 Doc Requirements"?

thank you,
marty

 

[[MVP] S.Clark]

Try the column headings property of the query.