Using ADO Filter property & distinct

Hi,

Is there any way to use ADO Filter property and SQL distinct together?
RecordSet.Filter = "SELECT DISTINCT COMPANY FROM blah blah.." doesn't seem to work.

Is there any other way to implement DISTINCT queries in SQL?

BR,
Mika