Filters and DISTINCT keyword

Is there a way to apply a filter to an ADO recordset that will filter records using the DISTINCT sql format?

I have tried but unless I open the recordset with something like
"Select DISTINCT FROM MyTable" it can't be done.

I can't specify a filter that has DISTINCT as part of the CRITERIA

Can anyone help?

John ;-)
Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!