Cross Tab Queries

[BID121]

Good Morning,
Hoping someone out their could help. Can a Crosstab query have multiple layers
of colum headings. Example this is what I would like my report to look like.
Top layer is salesman, Second layer is Product name shipped in New York or
Other State.
Abbarno Buckner Foley Jones Ryan
Totals
Product Name NY OT NY OT NY OT NY OT NY OT NY OT

Boston Crab meat 368 225 0 0 0 0 0 0 0 0
368 225
Chai 0 0 342 990 0 0 0 0 0
0 342 990
Filo Mix 0 0 0 0 93 75 0 0 0
0 93 75

 

[Duane Hookom]

There are some samples of multi-value crosstab reports at
http://www.invisibleinc.com/divFiles.cfm?divDivID=4. There are two mdbs in
the sample. Try the CrosstabReports.mdb. There is another method using a
cartesian/crosstab that might work also.