I've got a query that i want to update a field to a new value depending on what is originally stated in the field.
currently for my field [hst code for qb] I either have "Z" or "H" - this represents zero rated or hst applicable - and I realize i shouldn't have field names with spaces....this was committed to many years ago unfortunately.....
if i use the expression in my query as follows:
x: IIf([hst code for qb]="z","Zero-rated",[hst code for qb])
any record with the [hst code for qb] set to "z" converts to "Zero-rated" perfectly.
When i try to combine both i get errors, so i know i'm missing something in the AND / OR part of the expression.
x: IIf([hst code for qb]="z","Zero-rated",[hst code for qb]) And IIf([hst code for qb]="h","HST ON",[hst code for qb])
Can someone show me how to combine these two expressions into one larger one that i can use in my query?
thanks in advance.