I have created an update query, there is a "Floor" field that in the original table lists the building and the floor as a single value (SCC 1st Floor). I can easily remove the building code with a left function, the problem I have though is that the spaces between the building code and the floor is never the same.
Is there a way to us wild cards in a expression like the one I have below?
Floor: IIf (TempTable![Delivery Address] = "*1*", 1st Floor, Other)
Is there a way to us wild cards in a expression like the one I have below?
Floor: IIf (TempTable![Delivery Address] = "*1*", 1st Floor, Other)
