compare two fields

R

Ray Mead

Hi there, I have a query to compare two different fields, state and
originalstate. It works fine if the data is changed, but the query does not
include records where one of the fields is null. How do I include the null
values?

Thanks
 
K

Klatuu

Try this:

Nz([state],"")
Nz([originalstate],"")

I am assuming they are both text fields, if they are number, replace "" with 0
 
Top