MS Access Query Error

[chris1979]

Hi Guys
I have a requirement where I have select three different criteria in work. I have to select all the data which starts "BAN*" (rename as BLR), again select the data which starts MAD* and rename as CHN and the rest as Others
I have tried using switch, iff and like statements but never works
Team: Iff([City] Like "BAN*","BLR",IIf([Library Item] Like "MAD*","CHN","Others"))

 

[jackd]

Not enough info to offer focused response. Tell us about WHAT you are trying to accomplish in plain English and provide some info re your tables.
It is often more helpful if you show the SQL underlying your query.

I'm sure this is clear to you, but some explanation for the readers would help.
"rename as CHN and the rest as Others "
Good luck with your project.

 

[xenou]

I have tried using switch, iff and like statements but never works
Team: Iff([City] Like "BAN*","BLR",IIf([Library Item] Like "MAD*","CHN","Others"))

As far as it goes your expression looks correction enough except Access does NOT have an IFF function. It has an IIF function, so you need to fix that.

 

[chris1979]

Thank you for your feedback and time. I have tried the formula with some minor changes and it worked.
Thanks once again