Search results

  1. D

    Using MAX() or LAST() to get records most recent date

    Thank you very much. I think I'll hang around for a while :D
  2. D

    Using MAX() or LAST() to get records most recent date

    See, I tried it that way too. It makes logical sense, but instead of giving me the most recent datefield.record, it instead filters out all of the entries that have the same ID but different dates. i.e. from the original table uid|name|personnel#|end date 1|John Smith|1234|10/12/2009 2|Susan...
  3. D

    Using MAX() or LAST() to get records most recent date

    Worked perfectly, thank you very much
  4. D

    Using MAX() or LAST() to get records most recent date

    Table: SAP DED DUMP Query: qrySAP DED DUMP Original query SQL: Ok using a specific personnel number, I know there are two records for this query (using a particular person's id# in the place of nnnnnn as an example). What happens is an employee may change pay grades at any point in time...
Back
Top Bottom