var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: IIf Statement with a LIKE
Can't get my IIf statement in Access query to compile correctly.
Don't know if i'm adding the "like" statement correctly?
IIf([Consultant Specialty]= like "*anaes*","Pain Management",[Consultant Specialty])
You use LIKE instead of =, not in addition
you are star!
Originally Posted by pootle flump
Don't think you can do a = and like in 1 statement
Would rater use iif(instr(text,text2)>0 ,True,False)
it works perfectly
as this is a update query, is it possible to add this query to a make table query... for example -
Make table query-
Consultant Specialty: ([KORNERNAME])
IIf([Consultant Specialty]="Oral Surgery","Maxillofacial Surgery"[Consultant Specialty]))
can i put the update query into the same make table query, if so how?
thanks in advance
Ok - just to back up a bit - are you renaming multiple specialties? And is it possible that there might be changes in future to these renames (perhaps some new ones added)?