Results 1 to 2 of 2

Thread: Access Query

  1. #1
    Join Date
    Sep 2013
    Posts
    3

    Unanswered: Access Query

    I have the following query with me:

    Licence plate number____________KMS for maintenance_____Closing KMS
    A12345________________________5000________________ __1600
    B23456________________________4500________________ ___2500
    B23456________________________4500________________ ___3100
    C34567________________________3500________________ ___1700
    D45678________________________5500________________ ___2600
    D45678________________________5500________________ ___2850

    In the new query, I want only 1 record for each "Licence Plate number" corresponding to the the maximum "Closing KMS".
    There should be only 1 unique record for each licence plate number.

    Thanks
    Last edited by skunal; 09-11-13 at 04:27.

  2. #2
    Join Date
    Nov 2010
    Posts
    84
    In the attached example that you have wanted.
    Attached Files Attached Files

Posting Permissions

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