Cross Tab Query (1 Viewer)

Dear Experts!

Can i omit one column value and make a total in cross tab query. I have attached a sample screen shot for better understanding. From the column heading i need to get a total of all columns starting from "CROMPTON" till "TTC". Total should not include the "QDVC" Count. Could anyone tell me how it works!:banghead:

Q1 should have all records filtered you want to see.
Q2 is the Crosstab query using Q1.

Ranman256 said:

Q1 should have all records filtered you want to see.
Q2 is the Crosstab query using Q1.

Click to expand...

I would say its the other way round. Q1 is the crosstab, Q2 is based on Q1 and includes new columns that sum specific columns created in Q1.