Hello, I joined two query by autonumber ID's One query has 4 record and the other has 6 records. However on joining them I get 24 records this amount is due to duplicates what might be causing this. All that I want is the related fields from that query. I tried to groups the records in the query with the hope of only getting the six records from the primary query with related fields from the secondary query the the "group by" does not work. help?