I'm not sure what I'm doing wrong, hopefully someone can help me. In this field i have there are a few different variations of the "Stinger" (i.e. Stinger-Wet, Stinger-Dry, etc.). I'm trying to create a formula in access that just combines them both under one name, "Stinger". Yet, it's not working and returning my value.
IIf([qryPaintActuals]![Line]="*Stinger*","Stinger",[qryPaintActuals]![Line])
This isn't working, it just returns the original ones instead of combing them to "Stinger".
IIf([qryPaintActuals]![Line]="*Stinger*","Stinger",[qryPaintActuals]![Line])
This isn't working, it just returns the original ones instead of combing them to "Stinger".