IIF Query Help needed

[mattc66 via AccessMonster.com]

Hi All,

I have a query and I want to use an IIF statement to replace the data on a
feild.

The feild is called "Region" If the the Region data is blank I want it to
read "NA" and if not show the data.

What would be the proper syntax?

 

[John Spencer]

IIF([Region] & "" = "", "NA",[Region])

--
John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
..