* problem

Hello All,

I am using the following code to split one field into 3. It searches the
original field for text and then if it is there it fills one of the new
fields with that text.

IIf(([hons]="*PM.Cert*"),"PM.Cert",IIf(([hons]="*PM.Dip*"),"PM.Dip",""))

Now this worked fine the first couple of runs. However it has stopped
working now. It works fine if I take the * out, but unfortunaly the original
field has other text in it as well.

Any suggestions would be very helpful.
Many thanks James.

IIf([hons] Like "*PM.Cert*", "PM.Cert",
IIf([hons] Like "*PM.Dip*", "PM.Dip",""))

--
MGFoster:::mgf00 at earthlink decimal-point net
Oakland, CA (USA)

James wrote:
Hello All,

I am using the following code to split one field into 3. It searches the
original field for text and then if it is there it fills one of the new
fields with that text.

IIf(([hons]="*PM.Cert*"),"PM.Cert",IIf(([hons]="*PM.Dip*"),"PM.Dip",""))

Now this worked fine the first couple of runs. However it has stopped
working now. It works fine if I take the * out, but unfortunaly the original
field has other text in it as well.

Any suggestions would be very helpful.
Many thanks James.