Udate query

  • Thread starter Thread starter Todd
  • Start date Start date
T

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?
 
Todd said:
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?
Click to expand...

From the sound of it, yes. Null is neither equal to nor unequal to
anything said:
Will the query work if I include "is null" on the or line?
Click to expand...

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.
 
Back
Top