I am attempting to create a database that combines information from 2 sources. One is a time keeping system, Table A. The other is from a payroll system TableB.
I want to create a new table that uses all the data in Table A and and adds the SSN and ITemID from Table B. Two fields in Tables have to match. EmID from Table A has to match AIdent from Table B. Also Worked Department from Table A has to match DeptName in TableB.
I have to match multiple fields because some employees will work in multiple departments in a single pay period.
I've tried using Dlookup and I can't seem to get the data to merge properly. I keep getting hundreds of duplicate records.
I'm attaching a sample file with fake data that matches the structure of my real DB. Didn't want to share anyone's SSN.