Microsoft Access Expression- Need Help

[XiusyQ]

I have a report that shows first giving year in a feild titled "year" (i.e. 1974) in one column and would like the column I created next to it to calculate the total amount of years giving (i.e. 46) wich works great when I use the expression builder and input the following:

=(2011-[year])

However there are some year cells that are blank and display as #Error on the report and I surely can't run this report like this for staff. So I tried the following expression:

Iif(IsNull([year]),"NA",(2011-[year]))

But it is still showing #Error wherever there is a blank year cell. I even tried IsBlank and still got the same results, what am I doing wrong?

 

[kmote]

Try the following where A2 is the year such as 1972

=IF(ISNUMBER(A2), YEAR(TODAY())-A2, "N/A")

 

[XiusyQ]

This makes perfect sense to me (except I had to use IsNumeric) but it is now displlaying the following no matter what I do:

#Name?

 

[office politics]

i think that means access can not find a column name when one is needed.

did you replace a2 with [year]?

can you post what you entered?