Reading fields in querydef - how to find criteria

[aytee111]

I have a query and I am listing the fields and where they come from - this is working fine ("for each fld in qdf.fields"). I am also trying to list the criteria associated with that field but can't seem to find it. Is it possible to get this information?

[June7]

What do you mean by criteria - field properties?

[aytee111]

Any value in the "Criteria" line of query design.

[June7]

I ran some code that listed all the properties of a field in a query. 'Criteria' is not one of them.

I also ran code that listed properties of query. Criteria not there either but SQL is. The Value of SQL property is the full sql statement, including the WHERE clause.

[aytee111]

Thanks for testing that out for me. I was trying to avoid having to parse the SQL, there are so many variations and possibilities. But it seems that that is the only way to be able to document a query fully.