MS-Access Query

[praveenkumark]

Hi i need a query for the follwing

My Table has

Grp Comp Vt
===== ===== ===
G1 C1 V1
G1 C2 V2
G1 C1 V3
G2 C1 V4
G2 C2 V1

The result of the query shold be..

G1 2 3
G2 2 2

Actually it should return Group by grp
First Val = Grp
Second val=Unique Comp
Third Val=Count of Vt

[ADezii]

Hi i need a query for the follwing

My Table has

Grp Comp Vt
===== ===== ===
G1 C1 V1
G1 C2 V2
G1 C1 V3
G2 C1 V4
G2 C2 V1

The result of the query shold be..

G1 2 3
G2 2 2

Actually it should return Group by grp
First Val = Grp
Second val=Unique Comp
Third Val=Count of Vt

What exactly do you mean by Unique Comp? Wouldn't C1 be Unique within the G2 Grouping also? Do you mean the Last Unique Comp within a Group? Please explain.

[garethfx]

Crosstab it


Looks from yoyur description the way forward

Gareth