General discussion
June 21, 2002 at 02:45 AM
susan.monaghan

Microsoft Access – Print Most Recent Rec

by susan.monaghan . Updated 24 years, 1 month ago

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?

This discussion is locked

All Comments