Am using query designer and have an IIf issue.
Here is my statement:
MoldingSection: IIf([Pattern_Type]="Airset" & "*","Airset",[Pattern_Type])
Now to explain... sometimes the [PatternType] field is "Airset Line", or "Airset Floor" or maybe just "Airset" But in this field I want the result to be just "Airset" (dropping the 2nd word). But in some cases the result may be "Floor" or "SPO" in which case I want the real result to display.
I suspect that the "Airset" & "*" part of my code is at fault but I can't figure out what it should be.