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