IIF Expression Help

[Guest]

Hi,
I created the following expression in a query:

AorB: IIf([Group Name]="*A Auto Install*","Auto","Borrow")

I am trying to pull out the Group Names that have "A Auto Install" contained
within the name and return the name Auto. If the name does not include "A
Auto Install", I want it to return the word Borrow. My expression is not
correct because even when the name contains "A Auto Install", the query
returns Borrow.

Any help will be greatly appreciated.

 

[Guest]

Please disregard. I realized I used an equal sign instead of LIKE.