Our company is using an asterisk - * in the description to note an item's status. In a query, I want to select any item that has and asterisk in the description. The use of the same wild card in MS Access has presented some difficulty. I have been looking and trying solutions manually, but would appreciate help for this issue. The solution in Excel is =IFERROR(IF(FIND(CHAR(42),E5)>0,"Discontinued"),"").
Thank-you
Thank-you