New Field: iif([EventType] *CONTACT RESOLVED*, "Yes", "No")

A

Adam

Afternoon All !

I'm an Excel person whose starting to look at expanding my knowledge into
Access.

I have a query and I want to add a new field into the query which highlights
if another field in the query contains the word "Contact Resolved".

I've come up with the following formula:"New Field: iif([EventType] *CONTACT
RESOLVED*, "Yes", "No")"

But it doesn't work. This would in Excel so I can't figure where I'm going
wrong.

Can anyone help me please?
 
Top