CrosTab 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]

I believe this has been answered in a different news group. It is seldom
necessary to post to more than one NG. If you feel that you have to, you can
multipost the same, one message to multiple groups so you create the same
thread on multiple groups.