I'm looking for a function in VBA to use in my Access.
The function would return a string if a field contains a certain characters.
If field contains "i1" then in then result column we would have "inspection 1"
else if field contains "aa" then we would have "aircraft available"
else if field contains "e1" then we would have "elevator 1"