Crosstab column naming problem

[John]

Hi

I have the following crosstab query;

TRANSFORM Sum([Staff Figures All Years].Rqd) AS SumOfRqd
SELECT [Staff Figures All Years].D
FROM [Staff Figures All Years]
GROUP BY [Staff Figures All Years].D
PIVOT [Staff Figures All Years].Y;

When I try to force the pivot values to appear under three columns value1,
value2 and value3 as below, I get a 'Data type mismatch in criteria' error
when running the query.

TRANSFORM Sum([Staff Figures All Years].Rqd) AS SumOfRqd
SELECT [Staff Figures All Years].D
FROM [Staff Figures All Years]
GROUP BY [Staff Figures All Years].D
PIVOT [Staff Figures All Years].Y In ("Value1","Value2","Value3");

What is the problem and how can I fix it?

Thanks

Regards

[Tom van Stiphout]

On Sat, 29 Dec 2007 02:18:29 -0000, "John" <Jo**@nospam.infovis.co.uk>
wrote:

You got your Year off by one.
-Tom.

>Hi

I have the following crosstab query;

TRANSFORM Sum([Staff Figures All Years].Rqd) AS SumOfRqd
SELECT [Staff Figures All Years].D
FROM [Staff Figures All Years]
GROUP BY [Staff Figures All Years].D
PIVOT [Staff Figures All Years].Y;

When I try to force the pivot values to appear under three columns value1,
value2 and value3 as below, I get a 'Data type mismatch in criteria' error
when running the query.

TRANSFORM Sum([Staff Figures All Years].Rqd) AS SumOfRqd
SELECT [Staff Figures All Years].D
FROM [Staff Figures All Years]
GROUP BY [Staff Figures All Years].D
PIVOT [Staff Figures All Years].Y In ("Value1","Value2","Value3");

What is the problem and how can I fix it?

Thanks

Regards

[tina]

fix your computer's date, pls.
"John" <Jo**@nospam.infovis.co.ukwrote in message
news:Bs*********************@pipex.net...

Hi

I have the following crosstab query;

TRANSFORM Sum([Staff Figures All Years].Rqd) AS SumOfRqd
SELECT [Staff Figures All Years].D
FROM [Staff Figures All Years]
GROUP BY [Staff Figures All Years].D
PIVOT [Staff Figures All Years].Y;

When I try to force the pivot values to appear under three columns value1,
value2 and value3 as below, I get a 'Data type mismatch in criteria' error
when running the query.

TRANSFORM Sum([Staff Figures All Years].Rqd) AS SumOfRqd
SELECT [Staff Figures All Years].D
FROM [Staff Figures All Years]
GROUP BY [Staff Figures All Years].D
PIVOT [Staff Figures All Years].Y In ("Value1","Value2","Value3");

What is the problem and how can I fix it?

Thanks

Regards