Recent content by rickmays

You might try: CountService: Sum(IIf([Service] In ("Good", "Bad", "Excellent"),1,0)) - this is in a query.

Thanks for your help!

Interesting. I've never seen a sql statement with multiple where clauses before. It must be ANDing the wherecondition with the query that's in the report's record source.

Hi and thank you for your quick response. Do you have any idea where in MSDN that may be documented? I have searched, but the description I have found is very brief: WhereConditionOptionalVariantA string expression that's a valid SQL WHERE clause without the word WHERE. Thanks!

Does the where condition in the OpenReport method replace the report's underlying record source query or just change/add to it. I think I am seeing evidence of the latter, but can't find it documented anywhere. Thanks!