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?

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.

A textbox with a control source of:

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

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