Using the asterisk !!

  • Thread starter Thread starter Jacob Frankham
  • Start date Start date
J

Jacob Frankham

Hi

I am using an IIf statement in an update query, and I wish to test a fields
value to determine whether it has an asterisk at the end of it ie

officeName

Darlington *
Newcastle
Middlesbrough*
Hackney
Bristol etc etc

How do I do this?

I was using IIf([officeName] Like *" *",
however Access keeps adding quotation marks around the whole of the
comparison
ie it changes automatically to:

IIf([officeName] Like "*" *"",

which is not what I want

Aaaaggghhhh, how frustrating !!!!

Cheers

Jake
 
Back
Top