Removing Duplicate records

[Brett1230]

Organization/Suborganization	Traveler Last Name	Traveler First Name	TANum	Document Name	Document Type	Trip Type	Special Circumstances Trip Type	Trip Purpose	Current Status	Date of Current Status	Awaiting Status	Document Create Date	Signed Date	Last AO Approved Date	Current Version Completed Date	Departure Date	Return Date	Total Days TDY	Total Trip Expenses	Total Reimbursable Expenses	Reference	Reference Number	Type of Travel
DN520969700204N00	Jimmy	Jim	1N1TP4	NNGAINESVILLE121114_A01	AUTH	AA-ROUTINE TDY/TAD		SITE VISIT	ARCHIVE IMAGE SUBMIT	12/19/2014		12/8/2014	12/8/2014	12/9/2014	12/9/2014	12/11/2014	12/12/2014	2	$603.14	$603.14			Entitlement Travel
DN520969700204N00	Jimmy	Jim	1N1TP4	NNGAINESVILLE121114_A01	AUTH	AA-ROUTINE TDY/TAD		SITE VISIT	ARCHIVE IMAGE SUBMIT	12/19/2014		12/8/2014	12/8/2014	12/9/2014	12/9/2014	12/11/2014	12/12/2014	2	$603.14	$603.14			Entitlement Travel

[Brett1230]

Not sure if anyone can see my question so I am posting it here. I am trying to remove duplicates based on the TANum field. I am a novice and I can't seem to figure out how to make that happen. I posted a record as an example. Thanks for the help.

[June7]

See if this approach fits your situation http://www.techrepublic.com/article/...-access-query/

If table has a unique record identifier - autonumber would serve - there is an alternative method which might be just as complicated. Involves a query to return the TOP 1 ID for each TANum that has a count > 1. Review http://allenbrowne.com/subquery-01.html#TopN
Then another query to delete those records.
DELETE FROM table WHERE ID IN(Query1)