Results 1 to 2 of 2
  1. #1
    wnuczus is offline Novice
    Windows 7 64bit Access 2013 64bit
    Join Date
    Mar 2017
    Posts
    5

    Show in query only last record from table

    Hi i have db with Clients.

    I have query and 3 field

    1. Name
    2. Surname
    3. Choose


    Choose is table and have date about meeting.

    http://www.imagebanana.com/view/9rqg4inr/kwerenda.PNG

    Now I have problem because query show me each record with Imie and Nazwisko and Result I want only that show me



    Sebastian Golebniak and last Rezultat

    so I want only each line = one client with last result

    sorry for my grammar if you wanna more screen tell me please.

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    Last is relative. If you had an autonumber in the list then you can go to the largest #.
    but what do you consider the last record?

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Show view as table value from record
    By Lukael in forum Forms
    Replies: 6
    Last Post: 02-10-2016, 06:36 AM
  2. Replies: 3
    Last Post: 05-03-2015, 10:28 AM
  3. to show only last record from a table
    By intexumax in forum Access
    Replies: 3
    Last Post: 02-19-2013, 10:42 PM
  4. Replies: 1
    Last Post: 04-11-2012, 03:30 PM
  5. Replies: 3
    Last Post: 09-29-2010, 08:31 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums