Using a wildcard in a count function

[Bagels]

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.

[Welshgasman]

Either use Left(FailureMode,9)="Component"
or Like "Component*"

You cannot use = with *

After all it is not equal to what you are asking.

[Bagels]

Thank you very much. All it was was a stupid "=" sign .

[Welshgasman]

Please mark as solved then.