Count nr of unique group of records

[john]

I have a table with 5 fields. In a query I would like to make a count for
every unique combination of field 2,3, and 4. I fiddled with the count and
dcount option, but can't get it to work for more than one field. Next
question is if it's possible in such a query to show only those unique
combinations that have a count higher than 5.
Thanks,
john

[Terry Kreft]

SELECT DISTINCT F2, F3, F4
FROM Table6

Will give you the unique combinations of the three fields.

And
SELECT DISTINCT F2, F3, F4
FROM Table6
GROUP BY F2, F3, F4
HAVING Count(*)>5;

Will give you the unique combinations of 3 fields where there are more than
5 records with that combination.
--

Terry Kreft
"john" <jo**@test.comwrote in message
news:Dt********************@casema.nl...

I have a table with 5 fields. In a query I would like to make a count for
every unique combination of field 2,3, and 4. I fiddled with the count and
dcount option, but can't get it to work for more than one field. Next
question is if it's possible in such a query to show only those unique
combinations that have a count higher than 5.
Thanks,
john

[john]

Thanks. That did it!
john

"Terry Kreft" <te*********@mps.co.ukschreef in bericht
news:j8******************************@eclipse.net. uk...

>
SELECT DISTINCT F2, F3, F4
FROM Table6

Will give you the unique combinations of the three fields.

And
SELECT DISTINCT F2, F3, F4
FROM Table6
GROUP BY F2, F3, F4
HAVING Count(*)>5;

Will give you the unique combinations of 3 fields where there are more
than
5 records with that combination.
--

Terry Kreft
"john" <jo**@test.comwrote in message
news:Dt********************@casema.nl...

>I have a table with 5 fields. In a query I would like to make a count for
every unique combination of field 2,3, and 4. I fiddled with the count
and
dcount option, but can't get it to work for more than one field. Next
question is if it's possible in such a query to show only those unique
combinations that have a count higher than 5.
Thanks,
john