Select query

[crowegreg]

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!!

[alansidman]

I would do it with two queries.

SELECT Table1.Admin_ID, Max(Table1.ID) AS MaxOfID
FROM Table1
GROUP BY Table1.Admin_ID;


and then

SELECT Query1.Admin_ID, Query1.MaxOfID, Table1.Comments
FROM Query1 INNER JOIN Table1 ON Query1.MaxOfID = Table1.ID;

[crowegreg]

Thanks. This solves my problem.