Null Value in query

  • Thread starter Thread starter Allison
  • Start date Start date
A

Allison

In my select query I included four fields labeled :

DIFF 1 DIFF 2 DIFF 3 DIFF 4

they are all calculating the differences of other fields.


I noticed that when I tried to prepare an unmatched query
because some of the columns have zero's and some have
blanks that the zero's show up as unmatched??? How can I
program my above fields to show a blank not a zero?
 
Not sure exaclty what you are asking, but you need to use the Nz function to
change null values into 0's. Use the help file for more information. Using
Nz and changing null values to 0 will allow null and "0" to be equal.

Rick B





In my select query I included four fields labeled :

DIFF 1 DIFF 2 DIFF 3 DIFF 4

they are all calculating the differences of other fields.


I noticed that when I tried to prepare an unmatched query
because some of the columns have zero's and some have
blanks that the zero's show up as unmatched??? How can I
program my above fields to show a blank not a zero?
 
Back
Top