Home > IT Answers > Removing Duplicates
Dash1
45 pts.
 Removing Duplicates
Access 2003 query
I have 2 access tables. One has doctors and membership totals, the other has doctors and their addresses. When I join both in an inner join, the membership totals duplicate because of the doctors multiple addresses. Is there a way to have the membership total appear only once?

Software/Hardware used:
ASKED: September 19, 2012  5:52 PM
RELATED QUESTIONS
Answer Wiki:
Last Wiki Answer Submitted:  Be the first to answer this question.
All Answer Wiki Contributors:  Be the first to answer this question.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

That might be caused by a bad design.  You should have a main “doctors” table, in which each doctor appears just once, and an additional table were you can store all of the addresses registered for each doctor.

If the design cannot be changed, you would need something to differentiate the many records that a doctor can have in the table.  Something like a type of address, or priority, or address’ correlative, etc. 

carlosdl
 63,535 pts.