Within a table I have 3 fields:
ID
Admin_ID
Comments
The ID field is the key, and is an auto number field.
The Admin_ID field relates to the ID within another table that contains admin information.
The comments are what are unique.
Within this table, an Admin_ID can have many records.
What is the query statement to retrieve the most current record for each Admin_ID?
Thank you in advance!!