I'm trying to use a wildcard (*) in a count function and it's not working.
=Count(IIf([FailureMode]="Manufacturing Defect" And [ProductWithinWarranty]=True,0))
Works fine
=Count(IIf([FailureMode]="Component*" And [ProductWithinWarranty]=True,0))
Does not work, returns 0
The query the report is based on shows all the failure modes. For components, it's "Component- ABC", "Component- XYZ", etc. etc.
So i'm trying to count all the "Component_____" failures by using the wildcard, obviously i'm doing something wrong.