var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Cant get this VBA expression to work...
I'm trying to do a very simple query and one of the fields needs to be changed to "open" or "closed" if it starts with 'P'.
So I am writing this expression:
list: if(DwgType.Table = 'p*',"Open","Closed")
its returning an "undifined function "if" in expression" error.
I'm sure this is something really silly, but could someone give me a hand please?
Thanks, that moved things along, but for some reason it is only returning 'Closed'.
IIf(([KE0G_Drawings].[DwgRevInt] = 'P*'),'Open','Closed') AS List
Does anyone know what would cause that?
you need to use "like" instead of the equals sign.
Access XP & WinXP Pro
Thanks a lot!
That worked like a charm