Null to zero function

[Bass71]

Hi:

I am trying to set the "null to zero" function in a crosstab query, but it constantly returns no records. I've tried the IIf(isnull...) and that won't work either.


Thanks for your help................

 

[tlbroadbent]

The Nz function should work in the query. Did you include it in the criteria also? Please your query - at least the portion where you want to convert NULL to ZERO - so we can know where to begin. Terry

http://members.home.net/tlbroadbent/sqlarticles.htm

"The greatest obstacle to discovery is not ignorance -- it is the illusion of knowledge." - Daniel J Boorstin

 

[carolineJ]

Thanks a lot, it worked.