I'm not exactly sure how to do this, but I can't see why Access wouldn't be able to do it... I have tbl_1 which has the information I already have. I have tbl_2 which has information I want to append to tbl_1. How do I do this? Please see attachments for an example. In reality, tbl_1 has about 4133 records (10 entries for 1 item) and tbl_2 has 306 records (1 entry for 1 item). The reason for 10 entries to 1 item is each record has 2 separate identifiers.