I'm trying to select records from a table (select query) that have equal time stamps and the latest one in the table and it's not working.
If I use Last or Max of [Date] by itself, the selection works but as soon as I add the other fields I need then it's showing everything.
For example if I have 3 rows with a time stamp 08/21/2019 2:07:40 PM and 2 rows with a stamp of 08/21/2019 1:57:44 PM, Last or Max will return 08/21/2019 2:07:40 PM but with other fields I get all 5 rows when I only want the 3 that have the most recent date.
What would be the work around?