Finding most recent data in a table
I have a field that is a calculation that uses Max to find the record with the most recent date and I want to do something similar with finding the username that made an entry most recently. The username is stored in the same table as the date I am retrieving and unfortunately for me Max does not work to find a username. I have a script that finds all records that have a Y for a certain field and then I also want to see the most recent contact date for that record which I am doing by using Max but I also want to see the username that made the contact. Thanks in advance.