Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2015
    Posts
    31

    Unanswered: Query criteria question !

    Hello everyone,

    I have a question. I'm looking to find out whether there is a type of criteria i can put in my query that allows which forbids one record to have the same values as the following record (i.e duplicate).

    Any help is appreciated !

  2. #2
    Join Date
    Apr 2004
    Location
    Derbyshire, UK
    Posts
    789
    Provided Answers: 1
    Hi

    Not sure if this answers you question but you could look at using the DISTINCT and DISTINCTROW predicates

    Access help says:-

    DISTINCT Omits records that contain duplicate data in the selected fields.

    DISTICTROW Omits data based on entire duplicate records, not just duplicate fields.

    Access help has more info/example on this

    HTH


    MTB

Posting Permissions

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