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?