Crosstab Query - Additional Data

  • Thread starter Thread starter Michael
  • Start date Start date
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
 
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"
 

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

Similar Threads

Crosstab query - I need aditional information 1
problem with crosstab query 1
Crosstab query 1
cannot use the crosstab of a non-fixed column as a subquery 3
crosstab query problem 7
export crosstab query too many fields error 1
Access 2002 macro problem 3
Null to Zero in Crosstab Query 1

Back
Top