Hi all i am not able to run this query in the Form i am getting run time error
complex query like that
my query is
"Update UOM SET VALID = SWITCH(UOM LIKE '*Bag*','BG',UOM LIKE '*Basket*','EA',UOM LIKE '*Bottle*','BT',UOM LIKE '*Box*','BX',UOM LIKE '*Carton*','CN',UOM LIKE '*Case*','CA',UOM...