S Sam Oct 28, 2009 #1 I have a report that I will like the default values in some of the fields to be 0. Please help
K KARL DEWEY Oct 28, 2009 #2 I assume that you may have some records with null fields. Then use the Nz function in your query.
S Sam Oct 30, 2009 #3 Thanks. i am still learning. i read most of the Q &A in the forum but it still does not work. I tried NZ([field 1l], "0") in the format but it still does not work
Thanks. i am still learning. i read most of the Q &A in the forum but it still does not work. I tried NZ([field 1l], "0") in the format but it still does not work
