Iif Statement

[Benn]

Hi guys, I am having a few issues using the iif statments in Access.

Basically, I have a store database with one of fields being "Offer". This is a Yes/No data type. I use the label wizard to make labels that will go on my products.

The problem I am having is this -

If the "Offer" value = Yes or "True" I want to display "SPECIAL OFFER" across the label.

This is how far I have got -

Offer: iif([Offer]="True","SPECIAL OFFER","")

Obviously I am using the "Offer" field on the labels. The trouble is, it's just not working. I am placing the Iif statement in the query I use to find the labels that need printing.. I am doing this by putting the Iif statement in the next blank 'Field' field..

It might just be something simple and I hope it is..

Thanks for any help.

Ben.

 

[DJkarl]

Don't enclose the True in quotes, that makes it a string and not a value of -1.

 

[Benn]

Edit: It's all working now, thanks for the help.