Updating columns with data from a different layout

[StevieV]

Hi,

I have a source table with columns:
ID1 | PREFIX1 | PHONE1| TYPE1 | ID2 | PREFIX2 | PREFIX 2 | TYPE2
"1" | "001" | 555-5555 | "FAX" | "2" | "001" | "555-3434" | CAR

And a destination table with simply
ID | PREFIX | PHONE | TYPE
"1" | "001" | "222-2222" | FAX
"2" | "001" | "222-2223" | CAR


I am trying to make an update query where the destination table is updated with the records from the source table but I can't seem to figure out how to do it. I suppose I would have to use a IIF statement where if the ID is "1" then use PREFIX1 for Prefix, Phone1 for Phone and Type1 for type. If ID="2" then use Prefix2 for prefix, phone2 for phone and type2 for type?!
I'm a beginner with Access so any help would be appreciated

 

[Dugantrain]

You're needing an Append Query rather than an Update Query. You'll probably want two Append Queries, one to Append all of the records from the first part of the Source records and then another for the second part. Play around with the Append Query's graphical interface, if it doesn't make sense then post back.