Change query

an · Oct 1, 2004

Hello!
With:

TRANSFORM First(MyTable.Value) AS FirstOfValue
SELECT MyTable.Date
FROM MyTable
GROUP BY MyTable.Date
PIVOT MyTable.Param;
(Thanks JohnFol)

We get the result:

ParamA ParamB
Date1 Value1
Date2 Value2
(First value of both)

But I would like the next result:

ParamA ParamB
Date1 Value1 Value"x"
Date2 Value"y" Value2

because there are values in both parameters.

Thanks in advance.
an

Duane Hookom · Oct 2, 2004

If there is a value for Date1 and ParamB, it should show in your crosstab.
Maybe you could type in your actual records that you expect to result as
suggested.

an · Oct 5, 2004

Tanks for your reply.
an

-----Original Message-----
If there is a value for Date1 and ParamB, it should show in your crosstab.
Maybe you could type in your actual records that you expect to result as
suggested.

--
Duane Hookom
MS Access MVP

.