I know there are differences between standard query language and Access SQL, but the query I wrote basically is just like:

SELECT tbl1.field1, tbl2.field2, tbl3.field3 FROM tbl1, tbl2, tbl3
WHERE tbl1.ID = tbl2.ID AND tbl1.ID = tbl3.ID

In Access, it pulls the correct records, in the ADO code, it returns inaccurate/duplicate records. Do I just need to add tbl2.ID = tbl3.ID??? The query is a lot bigger then that but it is basically the same. I have also done it using INNER JOIN's and the same results occur; in Access it is correct, in ADO code, it is not. Thanks!

------------------
My Rig

Milhouse: "Remember when your dog ate my goldfish and you lied to me and said I never had a goldfish? Then why did I have the bowl Bart? Why did I have the bowl?"