Hello. I have an access 2010 table (table 1sample in the attached spreadsheet) that I need to append or update (via query or vba script) to another table (table 2 sample in the attached spreadsheet). I ultimately need to generate a report that looks like table 2 or is tied to table 2 sample. Can someone give some guidance on this. At least in script how I move the location number and name to columns. Thank you.