Null Value in query

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?
 
R

Rick B

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Criteria for make table Query 5
please help with this query 1
Cross Tab Query: "0" in null box 1
Blank Fields in NOT Null Query Criteria 5
Update query - fill in null field with value from record above 3
how do i write if and else statement in access query 8
Make table query not returning value for expression 3
Date Diff in a query or form 3

Top