How to append records to a table that already has those records...

[Triedtwice]

I can't seem to make an Append Query do what I want...any help will be appreciated!

I need to append records to a table called "tbl_6A_POP" from a table called "tbl_Media_Code". tbl_Media_Code has 7 records ("1000" thu "6000" plus "6500" in a field called "Media_Code"). tbl_6A_POP already has a field called "Media_Code" that has several hundred entries...an excerpt from tbl_6A_POP looks like this:

MC_PK	TTLM_No_PK	Media_Code	Rec_No
335	242	3000	19-39-5
336	242	3000	749-9-1
337	242	4000	56-55-378
338	242	4000	50-3-8
339	242	4000	20-9-2
340	242	4000	53-704-3
341	242	4000	13-9-5
343	244	5000	1479-73-001
344	244	5000	79-1-634
348	247	6000	NA_None
349	248	6000	NA_None
350	249	6000	NA_None

<tbody>
</tbody>

As you can see, there are multiple records for a given TTLM_No_PK, but not every Media_Code is recorded for each TTLM_No_PK. I need to append tbl_6A_POP to have each of the 7 records from tbl_Media_Code for each TTLM_No_PK in tbl_6A_POP. Even as I'm typing this, I realize I'm probably not making any sense...but if you might have a suggestion for getting the missing "Media_Code" records into the tbl_6A_POP table WITHOUT deleting the existing Media_Code records in tbl_6A_POP, I'll be a happy camper!

Thanks!

 

[Joe4]

You are welcome.

This may be of help, as it pertains to the join types: Creating Other Types of Joins | Working with Multiple-Table Queries in Access | Que
If you click on the images, they enlarge. See pictures may make more sense of what I was describing in my last post.