I have a qry with 2 qrys joined on securityId field. Each of the subQrys returns 101 rows by themselfs with 1 duplicated secId each. But the parent qry returns 104 records. 4 dupicates (2+2) ideas how to stop this?
You can set the query to return Unique Values or Unique Records in the query properties or use a Group By query. From the sound of your post, it seems like there may be an issue with the way the subqueries are linked. If you could post a bit more detail and some results, it would be helpful.