Results 1 to 4 of 4
  1. #1
    Join Date
    Apr 2006
    Posts
    5

    Unanswered: Find distinct records

    Is there an easy way to find distinct records, i.e. types rather than tokens, or do I have to write a loop which throws out the duplicates?

  2. #2
    Join Date
    Apr 2004
    Posts
    61

    Distinct records

    Well, if I understand your question, this is how relational databases excel.

    You can use a 'self-join' relationship to have records show on a layout when criteria (in a global field) matches. As you change the 'match' field the displayed records change.

    Does that help?
    If you are more precise with an example we can be more precise with answers.


  3. #3
    Join Date
    Apr 2006
    Posts
    5

    dinstinct records

    Here is an example:
    I have several blue cars, red cars etc. in the DB (field "color"), each car is a record. Now a script should tell me how many different colors I have, i.e. 3 if all cars are either blue, red or green, and 2 if they are either blue or red, no green cars.

  4. #4
    Join Date
    Aug 2005
    Location
    Minneapolis, MN
    Posts
    56
    There are different ways to do this, but it depends on what you mean by:
    Now a script should tell me...

Posting Permissions

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