Sorry! to post in this very old thread.

I think the filter can be done applying the COMPUTE statement as explained by Rob Macdonald in 'Serious ADO: Universal Data Access with Visual Basic',...