Easy way to exclude duplicate entries in recordset....

From: Matt S (S_at_discussions.microsoft.com)
Date: 12/27/04 

Date: Mon, 27 Dec 2004 13:43:06 -0800

Is there an easy way to exclude duplicate recordset entires using a filter or
some creative SQL trickery? I am not all that familiar with SQL, but I know
enought simple stuff to gt by.

I have data that looks like this..

Shape Class Size
W W14 W14x22
W W14 W14x26
W W16 W16x26
W W16 W16x31
W W16 W16x36
and so on

I want to filter the Field column such that the resutltant recordset only
contains one listing from each respective class I.E.

W14
W16
W18 and so on.

Is there an easy way to do this?

ANy help is appreciated.