K
ktwtennis
I'm trying to get something to this effect in my query:
Proj ID: IIf(([WoProjCode]="" or "99Z9999"),"09RM003",[WoProjCode]), where
if the projecct ID code is blank or has "99Z9999", I want it to go to
"09RM003", and if not, then I want it to default to its Project ID.
Many thanks for any help!
Kyle
Proj ID: IIf(([WoProjCode]="" or "99Z9999"),"09RM003",[WoProjCode]), where
if the projecct ID code is blank or has "99Z9999", I want it to go to
"09RM003", and if not, then I want it to default to its Project ID.
Many thanks for any help!
Kyle