Using a crosstab query in a Report 1

[M8KWR]

I am using A97 and am completely unsure how to create a report using a crosstab query - or if it can be done

Could anybody give me any suggesions or resources where i can find out.

Many thanks for any help in advance.

 

[GingerR]

Yes it can be done. After you write the crosstab query, the only way you can put it into a report is:

1) If the column headings will always be the same, list them in the Column Headings property of the query (i.e. Blue, Green, Yellow, Red). This way they are regular fields that you can put on the report.

2) If the column headings always change, it's more work. Search the forum for "crosstab" and find ways that people programmatically deal with that.

g

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244. Basics at

http://r937.com/relational.html

 

[Knicks]

I was just reading through your post and noticed that it would work perfectly for what I was doing ---- I had prior been exporting my crosstab to Excel for further work, but so much better being able to use as a Report in Access where I can also do the further totalling!

Awesome, take a star!