IIF statement with Like operator

[Vanessa_S]

I have put the following IIF statment in a select query;
sortgroup: IIf([Status]='Like A*',"A_GRP"). I have a
colum Status that can have the values 'AA', 'RA' or 'AR'
Where it found the character A the field sortgroup should
have the 'A-GRP' assigned. It does not work, can anyone
see what I'm doing wrong??? Many thanks! Vanessa.

 

[Michel Walsh]

Hi,


iif( status LIKE "A*", "A_GRP" )


The operator is LIKE, not =. You do not want something equals "like x",
textually, but something like "x", no?



Hoping it may help,
Vanderghast, Access MVP