Hi Guys,
Cotty,
Im not sure if i didnt follow your instructions right.. but the Employee ID's ended up missing after the Append Query had run.
Privateer,
I followed you instructions and it works. When I create a FORM from the QUERY and put the employeeID in, it pulls up the employee details...