Udate query

[Todd]

While trying to update a field in a table joined to another the update didn't
occur for all the records. Some of the reocords had null values. I tried to
update only the fields that <> the related fields. When I ran the update
query without the <> expression all of them appeared to update. Did the
fields with null values not update becuase they were null? Will the query
work if I include "is null" on the or line?

 

[Dirk Goldgar]

While trying to update a field in a table joined to another the update
didn't
occur for all the records. Some of the reocords had null values. I tried
to
update only the fields that <> the related fields. When I ran the
update
query without the <> expression all of them appeared to update. Did the
fields with null values not update becuase they were null?

From the sound of it, yes. Null is neither equal to nor unequal to

Will the query work if I include "is null" on the or line?

Probably, though of course I can't see your query. If you are comparing
multiple fields, make sure you have all the "or"s right.