SELECT DISTINCT Table1.Patient, Table1.MRN, Table1.DelTime, Table1.Type, Table1.Art, DMax("Ven","Table2","MRN = '" & [Table1]![MRN] & "'") AS VenMax
FROM Table1 INNER JOIN Table2 ON Table1.MRN = Table2.MRN;
My Results:
Patient MRN DelTime Type Art VenMax
John 12 01/01/2011 B 7.37 7.41
John 12...