If IsNull syntax in a query

[SDS100UK]

Hi,

I hope this is a really simply question.

I used if isnull in a query to replace empty field records with a 0.

But I xcannot seem to get it to work.

What I want to say is
if (isnull(calls),0,calls)

but it keeps erroring.

What am i doing wrong?

Many thanks in advance

Steven

 

[r937]

did you use IF or IIF?

rudy

http://r937.com/

SQL Consulting

 

[SDS100UK]

DOH!!!

I remember now....i used ut yrs ago and IIF is the answer....thankz Rudy!!!

 

[jwhjr]

You may also want to look into the Nz function, just search for it in the Access help for an explanation. Just another option to consider.

JR