* problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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",""))
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

MS ACCESS 2013 Long Text filed filter by another tables Long text field 1
Access query problem - Help 4
Access Query problem 1
Count text values in a Access Field 0
IIF function help in query 3
Text to Time converstion problem 2
Time format conversion 8
Data Conversion Expression returns #Error 2

Back
Top