View returns 0 records in Data Manager, 116 in Access query

[popodi]

I created a new instrument index view from the existing one and added a where condition to only show instruments on certain p&ids. However, the view in Data Manager returns no records. If I go under edit view and design with microsoft access and look at the data there, I get 116 records. I'm stumped. Is there a limit to the number of filters for DM views? Thanks!
I am including the query here.

[PartRidge]

Your If statement might be a problem for Data Manager to evaluate. When editting the view and looking at the results via MS Access direct it can figure it out. I've had trouble before and had to do some work arounds that are separate queries that then are used in the view you generate, but this sometimes makes the new view then only explicitly read-only.