Update query deletes content

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

Guest

I'm running an update query to unite two existing fields' content into the
first of the two fields. When I do, only fields which both had existing data
work, all others are blanked out. The query looks like:

Field: LOCATION
Table: tbl_alltree_bbbpipo
Update To: [LOCATION]+[LOC2004]
Criteria:
or:

thanks!
 
I'm running an update query to unite two existing fields' content into the
first of the two fields. When I do, only fields which both had existing data
work, all others are blanked out. The query looks like:

Field: LOCATION
Table: tbl_alltree_bbbpipo
Update To: [LOCATION]+[LOC2004]
Criteria:
or:
Click to expand...


Use the & operator rather than the + operator to concatenate the
strings. The + operator "propagates nulls" - that is, if either value
is NULL it returns NULL. The & operator treats a NULL as if it were a
zero-length string.

John W. Vinson[MVP]
 
Back
Top