Crosstab query - I need aditional information

[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

 

[John Spencer]

WHERE is this other data? Is it in the same table (or one of the tables) as
the table(s) used for the crosstab query?

If so, add the field to the query,
Change Group By to FIRST
Select Row Heading as the crosstab value.

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County