Using Wild card in Iif statement

  • Thread starter Thread starter Les
  • Start date Start date
L

Les

Could somebody please tell me if it is possible to use a
wild card in an Iif statement e.g. IiF([DC]="*PE","Y","N")

In other words i want it to find HZPE, AEPE, HEPE etc..

Your help is appreciated.
 
Thanks very much for your help.
-----Original Message-----
IIf([Right(DC],2)="PE","Y","N")


--
Duane Hookom
MS Access MVP


Could somebody please tell me if it is possible to use a
wild card in an Iif statement e.g. IiF([DC] ="*PE","Y","N")

In other words i want it to find HZPE, AEPE, HEPE etc..

Your help is appreciated.
Click to expand...


.
Click to expand...
 
Back
Top