compare two fields

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Try this:

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

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