Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2017
    Posts
    4

    Unanswered: show last record based on another field in a query

    I have a query named "last size". I am trying to get the query to show the last entry, by date, for each serial number. As I'm new to access I'm not sure where to start, would I be right in thinking I need DLookup? Any help very much appreciated.
    Attached Thumbnails Attached Thumbnails last size.png  

  2. #2
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    630
    Provided Answers: 34
    It takes 2 queries,
    Q1 to get the last dates....
    Q2 to get the records based on Q1

    Q1=
    Select ID, Max(date) from tData

    Q2=
    Select tData.* from tData,Q1 where tData.id=Q1.ID

  3. #3
    Join Date
    Mar 2017
    Posts
    4
    Quote Originally Posted by ranman256 View Post
    It takes 2 queries,
    Q1 to get the last dates....
    Q2 to get the records based on Q1

    Q1=
    Select ID, Max(date) from tData

    Q2=
    Select tData.* from tData,Q1 where tData.id=Q1.ID
    OK, think I get it, thanks

Posting Permissions

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