On Wed, 3 Sep 2003 01:44:44 +0200 in comp.databases.ms-access,
"lavasseur patrick" <pl**********@hotmail.com> wrote:
I would like
C1 C2 C3
---------- ---- ----
VINET 5 10
VINET 5 11
VINET 5 12
TOMSP 5 13
TOMSP 5 13
TOMSP 6 18
TOMSP 7 19
TOMSP 6 19
TOMSP 7 18
and to obtain
C1 C2 C3
---------- ---- ----
VINET 5 10
TOMSP 5 13
for the result
what should be the request ?
Looks like you want to group by C1 and use First() or Min() on the
others.
--
A)bort, R)etry, I)nfluence with large hammer.
(replace sithlord with trevor for email)