Display words based on another field???

[roadrage]

Hi could some one tell me if this is possible? I have a report that display fields based on a query. What i want is for the report to also include the words "Fantastic Choice" if the query returns "F" in the choice type field?

 

[MSAccessRookie]

Hi could some one tell me if this is possible? I have a report that display fields based on a query. What i want is for the report to also include the words "Fantastic Choice" if the query returns "F" in the choice type field?

If all you need is a single special case (F = "Fantastic Choice"), then using an simple IIf() Statement should get you what you want. If there is more than one special case, then you will need a compound IIf() Statement, or you might want to consider using a Select() Statement.

 

[pbaldy]

A textbox with a control source of:

=IIf(ChoiceType = "F", "Fantastic Choice", "")

 

[roadrage]

Thanks for your immediate replies, that works great thanks!!