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:
<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!
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!