Using Like in Query Field name

[mosh]

hi all,

I'm trying to create a field whereby IF the masterkey is Like Target, then "Target", else "not target".

But I can't seem to use the Like function in the field name and I get the error "You have entered a comma without a preceeding value or identifier".

here is what I have;

Expr1: IIf([MasterKey]= Like "*Target","Target","EPDQ")

I've highlighted the Like function because thats what it does'nt like. Can anyone help?

Thanks,
________
How to use soldering iron vaporizer

 

[namliam]

Just like... not = like...

Expr1: IIf([MasterKey] Like "*Target","Target","EPDQ")

You can only use one method of comparison
>
<
<>
!=
Like
=
They are mutualy exclusive...

 

[mosh]

Thanks Nam!
________
IOLITE PORTABLE