My table of PCusers logons consists of 6 columns, as follows :

PC address
UserID
Last Logon Day
Last Logon Month
Last Logon Time
Last Logoff Time

Unfortunately, my application can load the same info’ on more than one occasion.

eg
locn1 user1 17 Jan 09:29 09:37
locn1 user1 17 Jan 09:29 09:37

I know I can use the “distinct” command to limit one display per group.

However, it can happen that the 2nd load will return the same
PC address & UserID, but for a later time.

eg
locn1 user1 17 Jan 09:40
locn1 user1 17 Jan 09:29 09:37
locn1 user1 17 Jan 09:29 09:37
or
locn1 user1 17 Jan 09:40 09:42
locn1 user1 17 Jan 09:29 09:37
locn1 user1 17 Jan 09:29 09:37

Can anyone advise the syntax I need so that I only ever get the latest dataset displayed ?
Many thanks