Crosstab Query - Additional Data

[Michael]

Dear all in a follow up to another query I have run a crosstab query which
has given me the seperation of information I needed however as always I need
more!

Because I am exporting data from another d/b in access there is a certain
number of fields I need to have added, essentially I have run the crosstab
query it looks great but I now need to add additional note fields which
cannot be selected through the crosstab wizard. I tried adding them on at
the end in design view but it just ignores them.

Any help would be gratefully appreciated.

thanks you

Michael

 

[Arvin Meyer [MVP]]

Select the field and add it to the end. Make sure that the Totals box
carries the value "Group By", and the CrossTab carries the value "Row
Heading"