Delete first record if 2 fields are duplicated

[jyellis]

How is this done?



If [User Name] and [Wireless number] are duplicated then delete first record.

UserID	User Name	Wireless Number	Equip Chgs	Total Current Chgs
C201148	John Doe	555-215-1325	10.01	48.99
10265046	John Doe	555-215-1325	5.50	47.93

[aytee111]

What denotes the "first" record? Create a duplicates query using the wizard as your starting point.

[jyellis]

First record = UserID with 7 characters

[aytee111]

So you will be deleting all records that exist in the duplicates query where the userID has 7 characters.

[jyellis]

Yes and I want to do it; via query or vba