N
neeraj
I have a table of sales orders having the following columns:
SalesRepID SalesRepName MonthofSale Product Type Amount
1 AB Jan2006 C 10
1 AB Jan2006 C 10
1 AB Jan2006 N 30
1 AB Feb2006 C 40
2 ...
I want to create a crosstab query whose results look like the following:
Jan2006 Feb2006
C N C N
1 AB 20 30 40 0
2....
In other words, I have a column (Month) and subcolumns (ProductType).
I understand that Access allows only one column heading in a crosstab query.
I can do it with 2 row headings (ID and Name) and a column heading(Month) and
sum the Amount as value but there is a lot of redundancy that way. Is there a
way in Access that I can get my results in the way as desired and shown
above.
SalesRepID SalesRepName MonthofSale Product Type Amount
1 AB Jan2006 C 10
1 AB Jan2006 C 10
1 AB Jan2006 N 30
1 AB Feb2006 C 40
2 ...
I want to create a crosstab query whose results look like the following:
Jan2006 Feb2006
C N C N
1 AB 20 30 40 0
2....
In other words, I have a column (Month) and subcolumns (ProductType).
I understand that Access allows only one column heading in a crosstab query.
I can do it with 2 row headings (ID and Name) and a column heading(Month) and
sum the Amount as value but there is a lot of redundancy that way. Is there a
way in Access that I can get my results in the way as desired and shown
above.