Merging/Deleting Duplicate User Records

[tillmanj]

I am attempting to clean up some data for migration to a new system, and I am stuck on dealing with duplicated user records. The following fields in tblUser are germane to the problem:

UserID: primary key for the table tblUser
UserEmail: the field I am searching for duplicates on
UserLastLogin: the last time
review_count: the number of records in the linked table tblReview

What I would like to do is (in pseudo-code):

FOR EACH pair of records with matching UserEmail values:
IF oldest UserLastLogin review_count = 0
DELETE record with oldest UserLastLogin

IF ELSE oldest UserLastLogin review_count > 0
SET review IDs for oldest UserLastLogin to newest UserLastLogin in tblReview
DELETE record with oldest UserLastLogin

I am stuck trying to do this with queries and know nothing of using VBA to do it, so any pointers in either direction would be very helpful.

[puppydogbuddy]

The following link is a "How To" step by step. The only difference between what you want to do and the link is that the records retained are the oldest, and you want to retain the latest. The only change you have to make in the procedure is to replace the word "First" with the word "Last" in the query so that the query results contain the last (most recent) records.

Deleting Duplicate Records Leaving Just the First