Hi,

I need to get a result with crosstab query. The problem described as below:

Product Company Orders
A C1 4
B C2 6
C C1 10
D C1 2
E C2 5
F C1 7
G C1 8

I need to get the total numbers of orders group by some Product for each company C1 and C2, listed as below:
Product C1 C2
A-C 4+10 6
D 1 2
E-G 7+8 5

Is there a way to implement?

Thanks a lot for your kind help!

Can you give me more info on the data? You can do it but may have to do part of it with one query, and then total it with a second, or you may have to code some query results, etc.

HTH

mmcdonal

What if you create a new table with a field called "group" and field called product? For each product you would have a group identified. Using your example, Group 1 would include products A,B,C. Group 2 would include product D. Group 3 would include D,E, and F.

Grp Product
1 A
1 B
1 C
2 D
3 E
3 F
3 G

Product could be a primary key. Name the groups anyway you wish, I used 1,2,3 for the sake of brevity.

Relate product in the table above to the product in the table you showed. This should help with the grouping problem.