Change query

[an]

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]

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]

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





.