Hi Experts -
I'm trying to update a field in a table with the correct view; that is to show all Part Numbers in one field. If you look at my sample2
database; I have a field called PartNumber
and one called PartNumber2
I would like both of these numbers in the same field named NewPartNumber
in the same table.
Should I use an Update or Append query for this?
Thanks in Advance,