Crosstab within Crosstab

[GPM4663]

Hi Everyone,
I'm having a bit of difficulty setting this one up! I need to produce a report that looks like this

Type 1 Type 2 Type 3
Area1 %A %B %C %A %B %C %A %B %C
Area2 %A %B %C %A %B %C %A %B %C
Area3 %A %B %C %A %B %C %A %B %C

I can make the crosstab for getting %A %B and %C without being sorted by type or I can produce one that shows Type1, Type 2 and Type 3 with one value (%A or %B or %C) but I can't do both. If anyone has any ideas I would really appreciate it. The values % A etc. are calculated from values in a table.

Many thanks in advance,

GPM

 

[dhookom]

You can concatenate your two desired column heading fields together and produce unique values for each combination.

There are some sample crosstab reports at

http://www.invisibleinc.com/divFiles.cfm?divDivID=4.

If you provided some current sql or table and field names, we could be of greater assistance.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]