Back again looking for some help and guidance, I have a recordset and I want to loop through this recordset until I find the field with the highest date. I am have a basic knowledge of how it should work but I have no idea what way to express the condition that means do until lastdate . I am not to sure how clear I am being but any help would be appreicated as always.
This is all I got so far
Do While Not rs.EOF And (rs!NEXTDUEDATE > PNUM(2,ctr)) Let PNUM(1, ctr) = rs!LastOfEMPCODE Let PNUM(2, ctr) = rs!NEXTDUEDATE Let PNUM(3, ctr) = rs!LASTPERFDATE Let PNUM(4, ctr) = Eqnum rs.MoveNext Let ctr = ctr + 1 Loop