Duplicate showing in query when there shouldn't be
As a guess there are multiple records in one table that match up to records in
another table.
Simple example
TableOne has only two records with Values in fieldOne of 1 and 2
TableTwo has four records with values in field2 of 1,1,1 and 2
If you run a query with TableOne joined to TableTwo on FieldOne To Field2, you
will get four records returned
3 records for TableOne.FieldOne where the value of field one = 1
1 record for TableOne.FieldOne where the value of FieldOne =2
John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County
Jennifer wrote:
Hi,
So new to this I could pull my hair out. So go easy on me. Thank you for any
help you can offer.
I have 1 query that is pulling from 3 tables. In those tables there aren't
any duplicate entry's yet in the query i get duplicates for some entries. I
can find no correlation as to why it could be choosing these as duplicates.
Any direction?
|