Help with this query, Thanks

[theworm]

Can anybody help me out with this. here is my query, which works.



SELECT Entry.FullName, Entry.ClassTaken, Entry.Datetaken, Entry.DateExpires, Entry.NowCertified, Entry.Passyeswritten

FROM EMP INNER JOIN Entry ON EMP.FullName=Entry.FullName

WHERE entry.dateexpires>date() And emp.activeno=False;

This will return all of the records that I would expect, what I would like to have happen is to have only the most recent class taken returned. For example, there could be a user that has been certifed on an item over the last 3 years and this would return all 3 of those records. I would like to have only the most recent classtaken returned in the query.

Thanks for any help.

[pbaldy]

See if this helps:

http://www.baldyweb.com/LastValue.htm