ACCESS FEED: [MS_AccessPros] Most Recent Record

Rabu, 21 September 2011

[MS_AccessPros] Most Recent Record

I have a membership database where members sometimes change clubs. I
record their history in a table called "tMembersClubHistory" which
includes a field "DateJoinedThisClub" and another "Terminated".

I identify current members by the fact that they do not have a
terminated date. I am now building a history of the posts held by
members to include terminated members. In the case of a member who
has a history of membership over several clubs I need to identify the
most recent "DateJoinedThisClub".

Here is the SQL:

SELECT tMembersClubHistory.MemberID, tMembersClubHistory.DateJoinedThisClub
FROM tMembersClubHistory;

What criteria do I need to find the most recent?

Many thanks,

Robin Chapple