B
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
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