Duplicate problem

A

alvin

i am comparing two tables where both table contains values which has duplicates, example Table1 has three 20's and Table2 has five 20's. On my unmatched query the two 20's from Table2 where not shown, What's shall i do to address this problem

thanks

alvin
 
R

Reggie

Looks like you need to try to match on more criteria/fields. The 20's wont
show because though it's not a one for one match, you are only asking if
there is a match. In your case the answer is yes there is a match on 20's
so those records aren't returned as No Match!

--
Reggie

www.smittysinet.com
----------
alvin said:
i am comparing two tables where both table contains values which has
Click to expand...
duplicates, example Table1 has three 20's and Table2 has five 20's. On my
unmatched query the two 20's from Table2 where not shown, What's shall i do
to address this problem.
 
A

alvin

Thanks Reggie. But ideally the two unmatched 20's on Table2 were suppose to be unmatched and must be shown.
 
R

Reggie

Alvin, I see what you want, but on the other hand how does the application
know which of the 5 20's should be returned? Maybe if you used more
criteria like match on 20's and another field that may be present in both
tables, but have different/missing value's in one of the tables is.

--
Reggie

www.smittysinet.com
----------
alvin said:
Thanks Reggie. But ideally the two unmatched 20's on Table2 were suppose
Click to expand...
to be unmatched and must be shown.
 
J

John Vinson

i am comparing two tables where both table contains values which has duplicates, example Table1 has three 20's and Table2 has five 20's. On my unmatched query the two 20's from Table2 where not shown, What's shall i do to address this problem.
Click to expand...

That's because they ARE matched.

If any record in Table1 has a 20 in it, that is a match for a record
in Table2 with a 20 in it. It doesn't matter whether there is one such
record or a thousand - it's matched.

If you're assuming that a Table is like a spreadsheet, with row
numbers - it isn't.

What is the actual structure of your tables? Is there any other field
which would let you distinguish between these five 20's?
 
A

alvin

my problem is i have no unique record to consider yet. Btw,is it possible to use date as my unique record where there is timing difference on it, example: Table1 has a date of 18 May 2004 while Table2's date is 1 Apr 2004. Would ms access has the facility to compare the matched values on one of the table fields while making the sample date as unique record

thanks

alvin
 
Top