Hi everyone
So here's my current noodle scratcher:
I want to compare 2 recordsets (one is the current data, the other an import from a spreadsheet) both sets have a common field (membership number). If the membership numbers match, then run a query so the import set updates the current set; if there's no match then the import set appends the record to the live.
Simple I hear you cry! (or not as it turns out)
I can assemble recordsets, I can write the updates and appends all in VBA, but comparing the 2 records is making my head hurt.
Help!
So here's my current noodle scratcher:
I want to compare 2 recordsets (one is the current data, the other an import from a spreadsheet) both sets have a common field (membership number). If the membership numbers match, then run a query so the import set updates the current set; if there's no match then the import set appends the record to the live.
Simple I hear you cry! (or not as it turns out)
I can assemble recordsets, I can write the updates and appends all in VBA, but comparing the 2 records is making my head hurt.
Help!