Crosstab Query 1

[BAWC01]

Hi

I have a crosstab query;

TRANSFORM Count(Export_1.IATA) AS CountOfIATA
SELECT Export_1.Flight, Export_1.Dest, Count(Export_1.IATA) AS [Total Of IATA]
FROM Export_1
GROUP BY Export_1.Flight, Export_1.Dest
PIVOT Export_1.[0-45];

What I want to do is multiply the balues in the colums by 2, how can I do this

Thanks

Phil

 

[BAWC01]

Can anybody help with this

 

[easyit]

try:

TRANSFORM 2* Count(Export_1.IATA) AS CountOfIATA
SELECT Export_1.Flight, Export_1.Dest, Count(Export_1.IATA) AS [Total Of IATA]
FROM Export_1
GROUP BY Export_1.Flight, Export_1.Dest
PIVOT Export_1.[0-45];

EasyIT

 

[BAWC01]

Bingo

Simple but Excellent solves my problem

Thanks

Phil