How to remove duplicates

10-21-2009, 08:27 PM

TonyBender TonyBender is offline

Windows XP TonyBender uses Access 2007 (version 12.0)

Access 2007 (version 12.0)

Novice

Join Date: Oct 2009

Posts: 4

How to remove duplicates

I am working with MS Access 2007 and want to learn how I can remove duplicate entries from a table.

My table has two fields; one has markets, the second has products, and there are over a million rows of data. I now there are several thousand instances where one product appears twice in a given market.

Is there a way to query this table to eliminate all the duplicate entries within each market?

Thank you for any help.

Bookmarks

« Previous Thread | Next Thread »

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Remove Filter and GoToRecord	ombadboy	Programming	0	09-04-2009 05:35 AM
Remove contents from each field	nancyszn	Access	7	08-06-2009 01:41 PM
Pulling out duplicates	FREEEEEEDOM	Access	1	04-21-2009 08:37 PM
remove record count	theITguy	Access	1	03-06-2009 03:22 PM
Remove Quotes within Data Values	kfschaefer	Programming	0	02-26-2009 10:15 AM

All times are GMT -8. The time now is 08:14 PM.