Nz Function in a Query

[SheilaAlighieri]

Hi

I am sure this is a very easy question for the experts. I would like to add a Nz Function to one of my queries. I have a field Budget which I want to give a "0" value where there is a Null value. Is that possible?

What code should I use and where should I put in in my query?

Thanks!

Sheila

 

[jrbarnett]

Sheila,

Go into query design and instead of putting your Budget field in with no problems, use

Nz(Budget,0)


John