Printable View
Is there a function similar to the recordset.filter property that can take a query as an argument as opposed to simple and & or clauses. I want to make a query on a recordset passsed to me from another program. I don't have the option of modifying the existing query, I simply get a recordset passed to me.
I could be missing smthing
but why not use the .filter on the recordset passed to u?
The filter statement takes arguments in "field operator criteria". Say I have a thousand records, each with a parameter, a parameter value, and a parameter limit. The parameter value can string(off when should be on, multiple possibilities)) or numeric. Associated with each parameter is a separate parameter with a comment for the associated parameter. My goal is filter out the records with limit violations(numeric and string evaluations) as well as those paremeters with associated comments. The query would something like this
give me all the numeric type parameters with limit violations.
give me all the string type parameters with violations.
give me all the parameters with no violations but containing associated comments.
Maybe I am missing something, but I dont think I can do this with a simple filter. If you have other ideas, please share them.