Results 1 to 4 of 4
  1. #1
    messier is offline Novice
    Windows 10 Access 2016
    Join Date
    Mar 2020
    Posts
    18

    Display Max Date for each Record

    Hi there,
    I have a table which has 3 columns.

    Name : Tel : Record Entered Date
    ABC : 123: 1 May 2020


    DEF : 234 : 3 May 2020
    GHI : 345 :20 May 2020
    JKL : 456 : 15 Apr 2020

    My desired Output (below) would be for column 1 to display the max date in record Entered date as the data would have been correct till that date.
    Can someone help?

    Update Till : Name : Tel : Record Entered Date
    20 May 2020 : ABC : 123: 1 May 2020
    20 May 2020 : DEF : 234 : 3 May 2020
    20 May 2020 : GHI : 345 :20 May 2020
    20 May 2020 : JKL : 456 : 15 Apr 2020

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    I feel like missing some info but consider:

    SELECT Table2.Name, Table2.Tel, Table2.RecordEnteredDate, (SELECT Max(Table2.RecordEnteredDate) FROM Table2) AS MaxDate FROM Table2;
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    messier is offline Novice
    Windows 10 Access 2016
    Join Date
    Mar 2020
    Posts
    18
    Thanks so much!

  4. #4
    Join Date
    Apr 2017
    Posts
    1,673
    Or like:
    Code:
    SELECT ut.UpdateTill, t2.Name, t2.Tel, t2.RecordEnteredDate FROM Table2 t2, (SELECT Max(Table2.RecordEnteredDate) AS UpdateTill FROM Table2) ut

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

Similar Threads

  1. Replies: 2
    Last Post: 04-19-2019, 05:13 PM
  2. Replies: 10
    Last Post: 01-23-2016, 12:29 PM
  3. Replies: 11
    Last Post: 07-20-2014, 06:22 PM
  4. Replies: 6
    Last Post: 12-27-2012, 10:49 AM
  5. Replies: 2
    Last Post: 12-21-2012, 01:57 PM

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