What expression to use....

[dcarr]

I have created a query using an IIF statement. In the query I would like to search for a string and replace text based upon the criteria in the IIF statement. The query is shown below:

Local_Advert_Type: IIf([JanData02]![Client_Name] Like "++CLASSIFIED","C","D")

This like statement does not work? Can any one else suggest what I can use????

Thanks

 

[Mile-O]

The like statement won't work because you haven't used any wildcard criteria with it

Like "++CLASSIFIED"


is literally: equals "++CLASSIFIED"


Now,

Like "*++CLASSIFIED*"

might get you a result.

 

[dcarr]

Thanks very much that worked a treat!!