Help about the cross tab query

N

nilses

Hello,

I ve a crossTab Query like that and i would like summing
the rows from total to 3730IR except Type. I think it's
not possible because there are not word in SQL which
remove a field like this

"SELECT *, Excluding Type FROM [Table: DataBase General -
Selection Parc machine - MO9]"

If it true, we can do this in an other query after the
cross tab query if i want summing the product

"SELECT SUM(*) FROM [Table: DataBase General - Selection
Parc machine - MO9]"

TRANSFORM Count([Table: DataBase General - Selection Parc
machine - MO9].Type) AS CompteDeType
SELECT [Table: DataBase General - Selection Parc machine -
MO9].Type, Count([Table: DataBase General - Selection
Parc machine - MO9].Type) AS Total
FROM [Table: DataBase General - Selection Parc machine -
MO9]
GROUP BY [Table: DataBase General - Selection Parc
machine - MO9].Type
PIVOT [Table: DataBase General - Selection Parc machine -
MO9].Type;

This the result of my crosstab query

Type Total 3730 3730EE 3730IR
3730 49 49
3730EE 3 3
3730IR 19 19

Is it possible to summing only total and the other fields?

Thanks

Nilses
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

CrossTab Query with Min 3
How to display zero value in blank fields of Cross Tab query 0
Count records in 10 minute time period 4
Cross Tab Query 1
Crate Table Query - Closest to the 15th day..... 0
Cross tab query solution 4
Adding my own rows to a Union Query without adding another table? 4
dcount in a crosstab query 3

Top