Check two fields for contents if match enter text into another field

[Anonymous]

IF(WildMatch(Country,'*United States*'),'Referencible' )AS [Action]

AND

IF(WildMatch(Item Desc,'*Population*'),'Referencible' )AS [Action]

I want to combine the syntax above into one statement that checks Country field for United States and Item Desc field for Population. If both conditions are true the text ‘Referencible’ will be entered into the field Action for that record.  If not true the text 'N/A' will be entered into the field Action for that record.  Can you help?

[rubenmarin · Accepted solution]

Hi John, try with:
IF(WildMatch(Country,'*United States*') and WildMatch(Item Desc,'*Population*'),'Referencible','N/A')AS [Action]

[m_woolf]

Maybe:

IF(WildMatch(Country,'*United States*') and WildMatch(Item Desc,'*Population*'),'Referencible','N/A')AS [Action]