Simple query ends up with unwanted duplicates

[iris5426]

i'm doing a simple query to sort information in a phone list database using two tables and i end up with each record in the completed query repeating 31 times.  i have no idea why it's doing this or how to fix it...

 

[kathryn]

You probably don't have a join between the two tables.&nbsp;&nbsp;Look at your query in design view.&nbsp;&nbsp;Is there a line connecting the two linking fields?&nbsp;&nbsp;If not click from one and drag to the other.&nbsp;&nbsp;<br><br>If that's your problem, then this is your solution!<br><br>Hope this helps.<br> <p>Kathryn<br><a href=mailto: > </a><br><a href= > </a><br>

 

[Guest_imported]

Try to group them, it might resolve your problem<br>Good Luck. <img src=

http://www.Tek-Tips.com/images/happy.gif>

 

[DreewToo]

SELECT DISTINCT...that'll get rid of any dupes...