I have these tables:

EMPMAST

IDNO SURNAME
0001   Reyes
0002   Roberts
0003   Argent
0004   Wesley

ACTION

IDNO EFFDATE    DESC
0001   01/01/1996 Hire
0001   01/01/1997 Promote
0001   01/01/1998 Increase Wage
0001   01/01/1999 Transfer
0002   01/01/1997 Hire
0002   01/01/1999 Promote

What I want to display is:

IDNO SURNAME EFFDATE   DESC
0001   Reyes           01/01/1999 Transfer
0002   Roberts        01/01/1999 Promote

How do I query this? I am using Access 97. Thank you for your help :)