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

    Post Unanswered: DISTINCT Query Problem

    I am trying to do a distinct query on a single table - I am using the distinct query on two fields Add1, Add2, but want the results to output client title, forename & surname.

    Code as below

    SELECT tbl_Client_Info.Title, tbl_Client_Info.Surname, tbl_Client_Info.Forename
    FROM tbl_Client_Info
    WHERE (((tbl_Client_Info.Add1)="DISTINCT") AND ((tbl_Client_Info.Add2)="DISTINCT"));


    Can anyone help ?!?

    DOnald

  2. #2
    Join Date
    May 2002
    Location
    Atlanta, GA
    Posts
    117
    Hey Donald,

    Try and change your query to this:

    SELECT DISTINCT tbl_Client_Info.Title, tbl_Client_Info.Surname, tbl_Client_Info.Forename
    FROM tbl_Client_Info

    This will show distinct records for these three fields. If this is not what your trying to accomplish please specify a little better.

    Kal

Posting Permissions

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