Crosstab with Null Values

[ewong1]

I currently have a crosstab query that compares data for two years. The results look like this.

month 2004 2005
January 98% 95%
.....
Decemeber 98

What I am getting at is that the query returns null values for the fields that do not have data recorded for the months in 2005 because we have not reached them yet. Is there a way for me to make sure that at least the value 0 is entered in the null value areas?

 

[KenHigg]

Have you tried the Nz() function?

Simple - instead of your numeric fld, just do something like:

myNewFldName: nz(myOriginalFldName)

Would this work?

 

[ewong1]

duh! don't know why i didn't think of that.. thanks!