Results 1 to 3 of 3
  1. #1
    Join Date
    May 2004
    Posts
    38

    Exclamation Unanswered: query which allow for an equalling of previous record

    I have a query which displays two fields like so
    F1 F2
    8360 8348
    8348 8360
    8348 8328
    8360 8328
    8328 8360
    8348 8360
    8328 8348
    8360 8348
    8328 8360
    8348 8360

    I want to manipulate the query so it only displays those records in f1 which have the same value in f2 with the exception on the first record.

    thus it would end up giving me the follwoing records

    F1 F2
    8360 8348
    8348 8360
    8360 8328
    8328 8360
    8360 8348
    8348 8360

    Does anyone know how this can be done?

  2. #2
    Join Date
    May 2004
    Posts
    38
    I have had a look round and the only thing I can think of is the Exists predicate but that will only get the current record and not the previous record - a little stuck there must be a way though to be able to look at a previous record within the same query!

  3. #3
    Join Date
    May 2004
    Posts
    38
    I am assuming it is impossible to do this query?

Posting Permissions

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