I need a little help building a query in Access. I have a table that contains an Item Number, Event Description, and Event Time/Date. What I want to do is be able to see the last Event Time/Date and Event Description that happened to each Item Number.
Item #111 might have an event at 17:00, 20:00, and 21:00.
Item #222 might have an event at 18:00, 19:00, and 19:01.