two filters on a report

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

paula k - 30 Jan 2007 18:15 GMT

Simple question: How do I change the filter in the properties tab to do an
"or" filter:

PM_Name="Smith" OR Owner_Name="Smith"

how do I write the code or an or statement?

Thanks!

Reply to this Message

Duane Hookom - 31 Jan 2007 02:11 GMT

You would normally leave the filter property blank in a saved report. Use the
where condition in the DoCmd.OpenReport method to set the property.

Dim strWhere as String
strWhere = "PM_Name='Smith' OR Owner_Name='Smith'"
DoCmd.OpenReport "rptYourReport", acPreview, , strWhere

Signature

Duane Hookom
Microsoft Access MVP

> Simple question: How do I change the filter in the properties tab to do an
> "or" filter:
[quoted text clipped - 4 lines]
>
> Thanks!

Reply to this Message