I am trying to build a query which gives me the most recent entry Date from this kind of table in Access:
Name_1 Status_received Date 1
Name_1 Status_rejected Date 2
Name_1 Statud_re-entered Date 3
In other words, I want to print out only the most recent entry for Name_1. The Statuses do not
follow a specific pattern, so I can’t go by one status being more recent that another. The Name
field has duplicates, but when trying to analyze the entire Record, they are all unique, and therefore
they all print out.
Any suggestions?