Update...
The following works insofar as it does not error and does produce results - just not the result I need
Code:
SELECT TblOOTDetail_New.DaysAgedWhenClosed, TblOOTDetail_New.TrackNum, TblOOTDetail_New.UIN_MTF_OrderNumb, TblOOTDetail_New.RecDate, TblOOTDetail_New.AllInfoRecDt, TblOOTDetail_New.DateClosed, TblOOTDetail_New.BatchID, TblOOTDetail_New.DateFirstKeyed, TblOOTDetail_New.OOTReasonCode, TblOOTDetail_New.DipReason, TblOOTDetail_New.ResearcherComments, TblOOTDetail_New.ResearcherIntls, TblOOTDetail_New.AssigndToAssociate, TblOOTDetail_New.AssigndToDepartment, TblOOTDetail_New.ManagerComments, TblOOTDetail_New.Program, TblOOTDetail_New.Researched, TblOOTDetail_New.EmailSent, TblOOTDetail_New.RecrdID
FROM TblOOTDetail_New
WHERE (((TblOOTDetail_New.BatchID)=DMax("[BatchID]","[TblOOTDetail_New]","[TblOOTDetail_New]![OOTReasonCode] Is Null")));
This will pull back all the records with the most recent BatchID (DMax) where the value in the OOTReasonCode field is Null
What I need are all the records with Null in the OOTReasonCode field and where those records have a duplicate TrackNum pull only the most recent of those duplicate records
I hope I am explaining this so it makes sense...