Easy way to display the most recent status entry.
I started doing this in Excel, but could do this either in Access or Excel -- whichever is the simplest to implement and easiest run on a daily basis.
Attached is an example of the kind of status report I'm keeping at work for a new group of projects (not actual status). The list could grow to maybe 500 rows and 100 different Projects.
Status information is entered by Date, Project No and Status comment. There can be multiple Rows for the same Project in any day.
Date will just show the mm/dd/yy. I don't want to enter time of day. (in Excel, I am currently automatically copying the date from the previous row until I manually change it).
The problem to solve is how can I easily display just the most recent Excel row (or Access Record) information for each Project.