Results 1 to 4 of 4

Thread: query

  1. #1
    Join Date
    Sep 2013

    Unanswered: query

    I have a access query with vehicle records and some calculations with respect to the vehicle running kilometers.

    I want to create a new query with last record for each vehicle and filter out the rest. The final outcome I want is only last record entry for each vehicle.

    Can you please help me here ?

  2. #2
    Join Date
    Nov 2011
    We are not mind readers! Can you provide the table name, qry name and field names at least?

    Under your ID (Primary Key) choose Descending, in the top values box on the toolbar, type 1.
    This will give you alphabetically the last record in your table.


  3. #3
    Join Date
    Sep 2013
    The query name is [Master & Service details].
    Name of fields: [Licence Plate number] and [Closing KMS].

    There are multiple (daily) records for each licence plate number with its closing KMS.
    In the new query, I want unique record for licence plate number and its last closing KMS.

  4. #4
    Join Date
    Jun 2007
    Maitland NSW,Australia
    In your query Group on L Plate Number and Max on Closing KMS

Posting Permissions

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