Query Issue in MS-Access

[nrsanand]

Hi All,

I am unable to find out what is the error in the below query

IIf([a]<>0,(([a]-[b])/[a]),0) AS DIFF

a- decimal value
b- an integer
. When i run the query with the above condtion, i am not able to get the value.
Kindly advise whether this is right syntax or not.

[TheShabz]

Syntax-wise, it looks good to me, though "DIFF" might be an Access reserved word. Try changing it to something else.

What is the error you're getting?