I have a disconnected recordset that I am trying to do some ambitious filtering with. I know how to get what I need with a SQL filter but they do not work as an ADO recordset filter.
example: (SQL) Job > 100 AND Job < 200 AND Cost >
100
but ADO.Filter needs it like
(Job > 100 AND Cost > 100) OR (Job < 200 AND Cost > 100)
which returns an incorrect set

Any help on filtering multiple columns by multiple values with the ADO filter property would be greatly appreciated