Ignorance...

[an]

Hello!

I have a query with next result:

Param Value Date
A V1 01JAN04
A V2 02JAN04
B V3 01JAN04
B V4 02JAN04
B V5 03JAN04
B V6 04JAN04
....

I'm with difficulty to make a query to obtain next:

ParamA ParamB
01JAN04 V1 V3
02JAN04 V2 V4
03JAN04 V5
04JAN04 V6
....
31JAN04

I would like help for this.
Tahnks in advance.
an

 

[JohnFol]

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

 

[an]

Exactly!!!

JohnFol, many thanks for your fast help.
an

 

[an]

Oops...

Only display one value for each Param when there are more
that one (?)
How is possible to display all records, please?
Thanks.
an

 

[an]

(cont)
Ex:

01JAN04 and 02JAN04 both have values.

01JAN04:
ParamA = V1
ParamB = V3

02JAN04:
ParamA = V2
ParamB = v4