If you are using MS Access, you can use the LAST function/total method.You would want the last of each field and group by whichever field you want unique, such as the userid. You can apply sort ascending/descending to the ValueDate field to ensure the result is accurate.
If you are using SQL server commands, you can use TOP. I.e.:SELECT TOP 1 ValueDate FROM table_nameORDER BY ValueDate DESC;
Let me know if that works for you!
You appear to be offline, so if you would like to reply, please reply back and I will assist. Thanks!
I'm using SQL and the table has 1000's of rows. I need to return the most recent row for each task and person. SELECT TOP 1 won't do many any good as it will only return 1 row.
That gets me almost there. It's only pulling the last row of any task for each user. I need it to pull the last row for each task per user. make sense?
Column 'L.UserId' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.
Adding them to my GROUP BY clause gives me the same thing as earlier.