IIF Expression Help

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
Back
Top