Unanswered: Report that displays the most recent record.
I am slightly higher than a novice, but I've not worked in Access in about 3 years. I've managed to set up a small project tracking database for our department. I'm having difficulty building a query that only displays the most recent record entries.
Context: Users enter records ("Project Updates"). They may be working on more than one project, so they make entries for each of them. Currently, they can enter updates as often as they'd like. Some perform a "once-weekly" update, per project. Others prefer to enter updates as they occur through out the week. Each entry has a date field ("Status Date") and I'm trying to key my query on this field. I want to build a report that displays the most recent record (or Update) per project, per employee. I can't figure a way to do that or even if that's possible or the right approach.
I really appreciate the assistance. I still have a problem. There are 12 projects against which employees are making entries. With your recommended settings, the query returns 5 of them. Interestingly enough, the 5 records each share an 8/5/09 entry date. The latest updates for these 12 projects range from 7/31 to 8/5/09. Also, the last (or most recent) entry for any of the records is 8/5/09. Any thoughts on what could be the issue?