I want to compare two fields (A & B) in an Access Database. I want to add all the records in field A to Field B and delete all the records in B that are not in A. Pretty simple but I haven't had any luck. Field A is the master and is always changing. I want to make B do the same as A without clearing the existing records and refilling all the records in B.


This fills B:

Code:
With rstDownEquipF1            'Copy temp to Queue
        rstTempF1.MoveFirst
        Do While Not rstTempF1.EOF
            .FindFirst "EquipQIDF1 = '" & rstTempF1!TempQF1 & "'"
            If .NoMatch = True Then
                .AddNew
                !EquipQIDF1 = rstTempF1!TempQF1
                .Update
            End If
        rstTempF1.MoveNext
        Loop
    End With
I can't figure how to delete the extra records from B.
Thanks
Rel