Duplicates Question

[TotallyConfused]

I hope someone can help me with this. I have a very large list of mbrs and
addresses. Due to mbrs dependent on main subscriber there are multiple
instances of addresses. I can use mbr ids because they consist of text and
numbers at random . I need to narrow list to only once instance of address.
Which is the best way to do this? Thank you.

 

[Jerry Whittle]

Show us the SQL of a query that nearly gets what you need. Open the query in
design view. Next go to View, SQL View and copy and past it here.

Please provide some sample data to show the problem.

 

[NetworkTrade]

make a query on the address fields; and while in query design view; go to
'Properties' (make sure nothing is highlighted first)....and then one of
the options there is 'Unique Values' change that to 'Yes'....

this will give you a Distinct record result

but you can't have memberIDs or names...because those will differ....this
will only work on the address field(s) itself; plus also any variance in
spelling or punctuation of course will be considered different as well....so
there will probably be still quite a few actual duplicates....i.e. 100 Main
St vs 100 Main St. vs 100 Main Street

but this will definitely lower your duplicates...