By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
426,107 Members | 1,318 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 426,107 IT Pros & Developers. It's quick & easy.

Duplication of records keep appearing in query

P: n/a
I have 2 tables from which I am pulling data for my query. If I pull ID from
Table 1 and then pull corresponding measures from table 2, I get several
repeats of my records for each row. So, if there are 4 different possible
measurements for each ID, I get several repeats of each mesurment for each
ID. Any insight would be greatly appreciated.

Marianne
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
sw*********@yahoo.com wrote:
I have 2 tables from which I am pulling data for my query. If I pull ID from
Table 1 and then pull corresponding measures from table 2, I get several
repeats of my records for each row. So, if there are 4 different possible
measurements for each ID, I get several repeats of each mesurment for each
ID. Any insight would be greatly appreciated.

Marianne

Create a relationship between the tables if they are related.

Tools, Relationships, drag the common field from one table to the other.
Perhaps it is the ID field that is common to both?

--
'-------------------------------
' John Mishefske
'-------------------------------

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.