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
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