PDA

View Full Version : Multiple Filters with "or"



longjonsilvr
10-25-2012, 08:18 AM
I have 3 sets of filters I want to apply. I have no problem with the filter code, its the "Or" code between filters im struggling with.

Currently I have:

SetAutoFilter FieldName:="Start", FilterType:=pjAutoFilterThisWeek
SetAutoFilter FieldName:="% Complete", FilterType:=pjAutoFilterCustom, Test1:="does not equal", Criteria1:="100%"

Then I need "OR"

SetAutoFilter FieldName:="Start", FilterType:=pjAutoFilterThisWeek
SetAutoFilter FieldName:="% Complete", FilterType:=pjAutoFilterCustom, Test1:="does not equal", Criteria1:="100%"

Another "OR"

SetAutoFilter FieldName:="Status", FilterType:=pjAutoFilterLate
SetAutoFilter FieldName:="% Complete", FilterType:=pjAutoFilterCustom, Test1:="does not equal", Criteria1:="On Schedule"



Does anyone have any ideas how to replicate is filter in code.

JosephCraig
03-11-2013, 01:04 AM
I am looking for some function to simply the complicated validation task. If you get the solution please share here also.