Hi,
i have 2 tables now in access:
table 1 has 8 fields: office employee id, office employee name, description, account id, account info, period date,
table 2 has 4 fields: employee id, employee name, account id, date, account period date
office employee id and office employee name (table 1) will always be the same with employee id and employee name (table 2). they have different field names but it contains same info. (e.g: john sanders will always have the same name and same employee id in table 1 and table 2)
account id is basically a string of numbers xx-xxx-xxx-xxx-xx.
what im trying to do is update table 2 in relation to table 1. table 1 currently has 1000 people and table 2 has 5000 people. table 2 contains a list of people who are AND are not on table 1.
I ONLY need people who are on table 1 (e.g. if person A is on table 2, but not on table 1, then i dont want him on table 2 anymore).
the new table 2 would only have a list of people who are on table 1. the fields are going to be the same (employee id, employee name, account id, date, account period date)..
afterwards, i want to add the records on the new table 2 to an existing table (human resources data). i think the word im looking for is "append" on access.
can anyone help me with this?
there's no "record macro" option on access so im at lost here...
thanks!
Bookmarks