Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2002
    Location
    Nottingham - UK
    Posts
    113

    Unanswered: Distinct Query PROBLEM

    I am needing to do a distinct query on 2 address fields, add1 & add2 only. There are at one address for instance 4 clients registered to that address - hence the distinct query. But if I do a distinct on all fields it will return all 4 clients from that address.

    I then did the below query on the 2 add fields - but cannot figure out how i display Forename & Surname to a single address. Any Forename & Surname can be used from the address can be used if that helps !

    SELECT DISTINCT tbl_Client_Info.Add1, tbl_Client_Info.Add2
    FROM tbl_Client_Info;

    Any help much appreciated.

    DOnald
    Attached Files Attached Files

  2. #2
    Join Date
    Feb 2002
    Posts
    403
    I think you need more than one query here.

    First group forenames based on surnames and address.

    Then query for address instance only.

    Then query the two querires to achieve the desired result

Posting Permissions

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