Hi,
I have set up this query in the builder (sql below & db attached):
Code:
UPDATE Table3 SET Table3.Item = IIf([Table3]![Item]="Coffee","70%",IIf([Table3]![Item]="Tea","60%",IIf([Table3]![Item]="Herbal Tea","50%",IIf([Table3]![Item]="Vodka","100%",IIf(IsNull([Table3]![Item]),"Get a drink",[Table3]![Item])))));
This is working. Null fields are covered as well as those which are not the above are left unchanged.
How could I do a in the query builder instead or would this have to be done from a module?
Thanks