0

Hi All,

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
```

Rgds

Nora.