Cool. No Problem. Thanks Fish! There are two separate issues I'm trying to tackle. Here is a sample raw recordset, followed by the desired recordset:
- Name ID MaxOfCode Active Date
-
AMADNI01 CT-005 03/22/99
-
ANANJA01 CT-005 09/01/92
-
ANANJA01 CT-007 05/22/03 (that is 2003)
-
ANDRDJ01 CT-005 08/01/92
-
ANDRDJ01 CT-006 11/11/94
-
AQUIDE01 CT-005 05/03/93
-
AQUIDE01 CT-005 07/07/03 (that is 2003)
The recordset below shows both the "Max(Code)" and the "Max(Active Date) for the Max(Code)" for each person. My two separate needs are:
1) To just find the Max(Code) for each person without regard to the Active Date
2) To find the record with Max(Code) and Max(Active Date) for the Max(Code) for each person.
I state these separately only because I suspect 2) is a more complicated query. If 2) is super hard, then I might have the data integrity to key off of Max(Active Date) ignoring Code all together, but I'll have to look into that. Any help you can offer for either 1) or 2) is greatly appreciated!!!!
- Name ID MaxOfCode Active Date
-
AMADNI01 CT-005 03/22/99
-
ANANJA01 CT-007 05/22/03
-
ANDRDJ01 CT-005 08/01/92
-
AQUIDE01 CT-005 07/07/03