Duplicate showing in query when there shouldn't be
in [Getting Started]
|
Prev: Mail database - Stevie is desperate and needs tp pimp his services
Next: Can DLookup be used to compare to a control value.
From: Jennifer on 4 Feb 2010 04:43 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? -- Thank you, Jennifer
From: Steve Sanford limbim53 at yahoo dot on 4 Feb 2010 08:02 Hi Jennifer, What you have asked is akin to saying: "My car is making a funny noise, but it shouldn't". Details, details, details.. :) There might be a couple of MVPs that are psychic, but the majority of us (non MVPs)are not. It would be helpful (to start off with) to post the SQL of your query since we cannot see your database. HTH -- Steve S -------------------------------- "Veni, Vidi, Velcro" (I came; I saw; I stuck around.) "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? > -- > Thank you, > > Jennifer
From: John Spencer on 4 Feb 2010 08:46 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?
From: KARL DEWEY on 4 Feb 2010 12:01 You have what is known as a Cartesian effect. This happens when your tables are not properly joined. The quanity of records in one is multipled by the number of records in the other. Post the SQL of your query for suggestions on how to fix. -- Build a little, test a little. "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? > -- > Thank you, > > Jennifer
From: Jennifer on 5 Feb 2010 03:52
So I am sorry to say I don't have a clue how to find the SQL of my query. I can look at my query in design view but how to look in SQL? I am so used to Excel all the Access language has me pulling my hair out. -- Thank you, Jennifer "KARL DEWEY" wrote: > You have what is known as a Cartesian effect. This happens when your tables > are not properly joined. The quanity of records in one is multipled by the > number of records in the other. > > Post the SQL of your query for suggestions on how to fix. > > -- > Build a little, test a little. > > > "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? > > -- > > Thank you, > > > > Jennifer |