Duplicate Entry in Query Return

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am running a query using 2 tables in which the return should show only
those with matching data in the last name and first name. Have tried
selecting unique values in properties, but when the query is run it will
"fill in" the query with duplicate records to match the number of records
from first table. I use the auto number to determine the fields are
duplicate. Is there a way to return only those matching, regardless of
whether there are 30 in one table and only 28 in the other table, or does it
have to return even amounts?
Example: Last: First Auto# Last First Auto #
Murphy James 2868 Murphy James 33
Murphy James 2870 Murphy James 33
 
Do you have a join set up between the two tables? In the query grid
there should be a line going from last name to last name and first name
to first name.

If you have that set up then if you have two records in either table
with the names James Murphy then you will get two rows returned. If you
have two James Murphy in both tables then you will get four rows returned.
 
Yes, I have thejoin property as one to one and it does return just those
names, but it will duplicate one record if there are more matches on one
table then there is in the other table. Is there a way to eliminate that
extra fill-in record so it doesn't show it?
 
Back
Top