Complex Query

[Brogrim]

I have 2 tables that I want to build a complex query off

tblBadgeMemberDuplicates
MemberID (PK)

tblBadge
MemberID (FK)
DateOfIssue
DateOfExpiry

Each member has 2 badges in tblbadge, I want to filter 1 badge for each member, I want the badge to be the one with the highest date in the date of issue field.

Thanks

 

[PHV]

A starting point (SQL code):
SELECT MemberID, Max(DateOfIssue) AS LastIssue
FROM tblBadge
GROUP BY MemberID

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886