By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,560 Members | 949 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,560 IT Pros & Developers. It's quick & easy.

MS-Access Query

P: 2
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
Aug 4 '07 #1
Share this Question
Share on Google+
2 Replies


ADezii
Expert 5K+
P: 8,669
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.
Aug 4 '07 #2

P: 49
Crosstab it


Looks from yoyur description the way forward

Gareth
Aug 4 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.