combine contents of two fields with the result replacing one of .

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

Guest

Single table:
Need to combine the contents of (field1+field2) and use results to replace
the original field1 for the entire table
ie Field1 Field2
Part Num Condition

7E9878 U


Result 7E9878U is now value of field1

Skip to next, next, next to table completion
 
Build an update query.

Update field 1 with...


=[Field1] &[Field2]



Then delete field 2 from your table after you run the update.

I always make a backup before I run an update or append query.


Rick B
 
Back
Top