Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2003
    Posts
    233

    Unanswered: Stopping duplicated rows in a qry

    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?

  2. #2
    Join Date
    Apr 2004
    Location
    metro Detroit
    Posts
    634
    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.

  3. #3
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    how have you defined the relation ship between the queries
    it maybe a good idea to post the SQL here

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •