Crosstab query - I need aditional information

M

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
 
J

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
 

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

Top