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
"Ray Mead" wrote:

> 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