Triedtwice
New Member
- Joined
- Feb 17, 2014
- Messages
- 31
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:
[TABLE="width: 350"]
<tbody>[TR]
[TD]MC_PK[/TD]
[TD]TTLM_No_PK[/TD]
[TD]Media_Code[/TD]
[TD] Rec_No[/TD]
[/TR]
[TR]
[TD]335[/TD]
[TD]242[/TD]
[TD]3000[/TD]
[TD]19-39-5[/TD]
[/TR]
[TR]
[TD]336[/TD]
[TD]242[/TD]
[TD]3000[/TD]
[TD]749-9-1[/TD]
[/TR]
[TR]
[TD]337[/TD]
[TD]242[/TD]
[TD]4000[/TD]
[TD]56-55-378[/TD]
[/TR]
[TR]
[TD]338[/TD]
[TD]242[/TD]
[TD]4000[/TD]
[TD]50-3-8[/TD]
[/TR]
[TR]
[TD]339[/TD]
[TD]242[/TD]
[TD]4000[/TD]
[TD]20-9-2[/TD]
[/TR]
[TR]
[TD]340[/TD]
[TD]242[/TD]
[TD]4000[/TD]
[TD]53-704-3[/TD]
[/TR]
[TR]
[TD]341[/TD]
[TD]242[/TD]
[TD]4000[/TD]
[TD]13-9-5[/TD]
[/TR]
[TR]
[TD]343[/TD]
[TD]244[/TD]
[TD]5000[/TD]
[TD]1479-73-001[/TD]
[/TR]
[TR]
[TD]344[/TD]
[TD]244[/TD]
[TD]5000[/TD]
[TD]79-1-634[/TD]
[/TR]
[TR]
[TD]348[/TD]
[TD]247[/TD]
[TD]6000[/TD]
[TD]NA_None[/TD]
[/TR]
[TR]
[TD]349[/TD]
[TD]248[/TD]
[TD]6000[/TD]
[TD]NA_None[/TD]
[/TR]
[TR]
[TD]350[/TD]
[TD]249[/TD]
[TD]6000[/TD]
[TD]NA_None[/TD]
[/TR]
</tbody>[/TABLE]
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!
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:
[TABLE="width: 350"]
<tbody>[TR]
[TD]MC_PK[/TD]
[TD]TTLM_No_PK[/TD]
[TD]Media_Code[/TD]
[TD] Rec_No[/TD]
[/TR]
[TR]
[TD]335[/TD]
[TD]242[/TD]
[TD]3000[/TD]
[TD]19-39-5[/TD]
[/TR]
[TR]
[TD]336[/TD]
[TD]242[/TD]
[TD]3000[/TD]
[TD]749-9-1[/TD]
[/TR]
[TR]
[TD]337[/TD]
[TD]242[/TD]
[TD]4000[/TD]
[TD]56-55-378[/TD]
[/TR]
[TR]
[TD]338[/TD]
[TD]242[/TD]
[TD]4000[/TD]
[TD]50-3-8[/TD]
[/TR]
[TR]
[TD]339[/TD]
[TD]242[/TD]
[TD]4000[/TD]
[TD]20-9-2[/TD]
[/TR]
[TR]
[TD]340[/TD]
[TD]242[/TD]
[TD]4000[/TD]
[TD]53-704-3[/TD]
[/TR]
[TR]
[TD]341[/TD]
[TD]242[/TD]
[TD]4000[/TD]
[TD]13-9-5[/TD]
[/TR]
[TR]
[TD]343[/TD]
[TD]244[/TD]
[TD]5000[/TD]
[TD]1479-73-001[/TD]
[/TR]
[TR]
[TD]344[/TD]
[TD]244[/TD]
[TD]5000[/TD]
[TD]79-1-634[/TD]
[/TR]
[TR]
[TD]348[/TD]
[TD]247[/TD]
[TD]6000[/TD]
[TD]NA_None[/TD]
[/TR]
[TR]
[TD]349[/TD]
[TD]248[/TD]
[TD]6000[/TD]
[TD]NA_None[/TD]
[/TR]
[TR]
[TD]350[/TD]
[TD]249[/TD]
[TD]6000[/TD]
[TD]NA_None[/TD]
[/TR]
</tbody>[/TABLE]
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!
