Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2013

    Question Unanswered: Previous record in query

    Can anyone help me? I added a database.

    place, time, gap, matches what I need in query
    11, a, a, a
    12, b, S, a
    13, c, S, a
    14, d, S, a
    15, e, S, a
    16, f, S, a
    17, g, g, g
    18, h, h, h
    19, i, S, h
    20, j, S, h
    21, k, S, h
    22, l, S, h
    Attached Files Attached Files
    Last edited by Aivo; 04-24-13 at 05:25.

  2. #2
    Join Date
    Nov 2004
    out on a limb
    Provided Answers: 59
    Can you elaborate a bit more about your requirement
    how do you know which is the approrpiate 'previous' record
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Apr 2013
    How can I put loop into that formula so every time when in "gap" column field is "S" ("Same" in an attachement, it takes one field up till it's not "S" ("Same").

Posting Permissions

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