Update query deletes content

W

wil_usgs

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!
 
J

John Vinson

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]
 
Top