Question

  • Creator
    Topic
  • #2270089

    Acess 2007

    Locked

    by paul.kimber ·

    I am importing data from a payroll system. This bring in details of each salary increase incluidng the applicable date of the increase. However I want to exclude all but the last record(i.e. the most recent record based on applicable date). I tried ‘last’ and ‘dlast’ but either I’m doing it wrong or it isn’t the right function. Can anyone help?

All Answers

  • Author
    Replies
    • #2601247

      Clarifications

      by paul.kimber ·

      In reply to Acess 2007

      Clarifications

    • #2601134

      Use MAX

      by rkuhn040172 ·

      In reply to Acess 2007

      In Access 2002/2003, you could change it to a Cross Tab query, select MAX and then change it back to a Select query and that was pretty much the fastest, easiest way.

Viewing 1 reply thread