Using Wild card in Iif statement

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.
 
G

Guest

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