I am trying run a update/append query so when the records match it will update the location and then add when the record doesn't exist yet. I apoligive for the messy table below but I keep getting an eror message trying to upload a excel file.
Table 1 Table 2 Table 1 becomes Name Code Building Floor Name Code Building Floor Name Code Building Floor Doe, John 12321 DE 2 Smith, Steve 432342 ME 2 Doe, John 12321 DE 2 Smith, Steve 432342 DE 3 Johnson, Jim 13432 ME 3 Smith, Steve 432342 ME 2 Allen, Joe 454 ME 2 Johnson, Jim 13432 ME 3 Allen, Joe 454 ME 2 What changed