G
Guest
I have a main parent table of emplyees. I obtained an excel table of names
and addresses from Human Resources which I imported without a problem and I
have compared the two. Because of different employee classifications a number
of employees from my parent table are not in the excel table I obtained. I
have been trying different queries but cannot get the two combined in a way
to that I have a list of all employees with and without addresses. I am
guessing the tables are not related correctly. The end objective is just a
simple form with all the employees showing from my main table and address
fields full or not so I can update and add addresses for those I do not have.
The two tables have SSN fields which can match employees and I also have an
autonumber primary key for both tables. What am I missing? Than You.
and addresses from Human Resources which I imported without a problem and I
have compared the two. Because of different employee classifications a number
of employees from my parent table are not in the excel table I obtained. I
have been trying different queries but cannot get the two combined in a way
to that I have a list of all employees with and without addresses. I am
guessing the tables are not related correctly. The end objective is just a
simple form with all the employees showing from my main table and address
fields full or not so I can update and add addresses for those I do not have.
The two tables have SSN fields which can match employees and I also have an
autonumber primary key for both tables. What am I missing? Than You.