I have a temporary table that imports employeeID and phone numbers associated to that employee
field: PHN_1 ' a phone number for residence
field: PHN_2 ' a phone number for cell
field: PHN_3 ' etc
The table it needs to update or amend is laid out differently:
field: EmployeeID 'linked field with EmpID
field: Type 'text field showing type of number - cell, residence etc
field: Number 'applicable number
So, I am trying to figure out what query to create to update tblEmployeePhone so that it adds the employeeID and then PHN_1 is added as the residence type phone number, PHN_2 is added as the Cell phone type phone number and so on.
I don't think it can be done as a sigle query but maybe by going through the recordset?