Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

simple query ends up with unwanted duplicates

Status
Not open for further replies.
iris5426

iris5426

Technical User
Aug 4, 2000
2
US
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...
 
Sort by date Sort by votes
This is probably due to your join criteria. Access will produce a row for everytime the join criteria is equal. Maybe you can add additional keys to pare down what will be returned. If you need additional help, then give more information on your tables and the keys that you are using to join on or could use to join on.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

ameedoo3000
  • Locked
  • Question
Clear all table contents without deleting records
Replies
15
Views
986
ameedoo3000
ameedoo3000
pankajunk
  • Locked
  • Question
I want to set up a simple meeting b
Replies
2
Views
334
lameid
lameid
atadbitslow
  • Locked
  • Question
comparing fields, one populated with data and one blank 2
Replies
8
Views
735
atadbitslow
atadbitslow
TrekBiker
  • Locked
  • Question
Style change after Windows Update
Replies
0
Views
497
TrekBiker
TrekBiker
cimoli
  • Locked
  • Question
Best password method with time factor
Replies
3
Views
431
cimoli
cimoli

Part and Inventory Search

Sponsor

Back
Top