I am new to microsoft access and I am trying to put a criteria on my query. But I got an error message saying"The expression you entered contains invalid syntax. You may have entered an operand without an operator" I don't know what needs to be fix. Please help me out. Thank You.
If the stock is higher
If there are 7 or more in stock then display High. If there are between 4 and 6 in stock then display Medium. For those with fewer than 4 in stock display Low.