Table using wildcards in field

[Ekhart]

Can I use wildcards in the field for a table?


We pull data from a warehouse we do not have control over that has very specific titles in it. We generalize these on our end but do not want to replace that data.
Example: 'IC/IFC Interfacility Consult Pain' and 'IC/IFC Interfacility Consult Surgery' would both be kept on our end as 'IFC'. Right now I have a table that links the specific names to our 'nicknames' if you will. I just wondered if I can simplify this for the ones that are very similar. For instance all titles that begin 'IC/IFC' would be nicknamed IFC.
Would it be easier doing this on a query level vs having a table with relationships?

What I was looking for was similar to just being able to enter 'IC/IFC*' in the field of the table.

[Bulzie]

In a new column:

Nickname: IIf(Left([YourField],6) = "IC/IFC", "IFC", "Somethingelse")
or
Nickname: IIf([YourField] Like"IC/IFC*", "IFC", "Somethingelse") Not sure this syntax is correct

[orange]

Cross posted with responses at http://www.utteraccess.com/forum/ind...ic=2047069&hl=