like statement help

[deebaglee]

hi i am trying to drop a formula to highlight if a operator has booked off a job incorrectly
i tried this
If LooksLike ({@123}, ["BC","BE","SC","BP","SE","SP","CL","HC","DC","NPD"]) Then "" ELSE "WARNING ERROR INCORRECT BOOKING OFF"
but i keep gettingtold a string is required just before the [

also i need some help trying to write a formula something like this

if right(field),3 = isnot like ["BC","BE","SC","BP","SE","SP","CL","HC","DC","NPD"]) then "error detected"
cheers

 

[Ngolem]

Try this instead

whilePrintingRecords;
If {@123}in {BC","BE","SC","BP","SE","SP","CL","HC","DC",
"NPD"]) Then
""
ELSE
"WARNING ERROR INCORRECT BOOKING OFF";

*****************************************

WhilePrintingRecords;
if right((field),3) in ["BC","BE","SC","BP","SE","SP",
"CL","HC","DC","NPD"]) then
""
else
"error detected";

those should do the trick





Jim Broadbent

 

[deebaglee]

thanks will try it tomorrow at work

cheers

 

[deebaglee]

WhilePrintingRecords;
if right((field),3) in ["BC","BE","SC","BP","SE","SP",
"CL","HC","DC","NPD"]) then
""
else
"error detected";
worked perfectly
thank you