Retrieve most recent date.

C

Chiral

I have a table with a bunch of fields, including a repeated secondary key (a link to another table) and a date field. I need a query which will show only the most recently dated record, for each value of the secondary key.
And I can't work out how to do it...
 
B

Brian Camire

You might try a query whose SQL looks something like this:

SELECT
[Your Table].*
FROM
[Your Table]
WHERE
[Your Table].[Your Date Field] =
(SELECT
Max([Self].[Your Date Field])
FROM
[Your Table] AS [Self]
WHERE
[Self].[Your Linking Field] = [Your Table].[Your Linking Field])

See

http://www.mvps.org/access/queries/qry0020.htm

for other alternatives to this approach.

Chiral said:
I have a table with a bunch of fields, including a repeated secondary key
Click to expand...
(a link to another table) and a date field. I need a query which will show
only the most recently dated record, for each value of the secondary key.
 
K

Kent Prokopy

Correctio

NOT First of id field

SELECT MAX(DATEFIELD), SECONDID FROM MYTABLE GROUP BY SECONDID
 
Top