peek question

[amien]

NetDateTime,
Peek('NetDateTime') As Peek,
User

FROM....

Peek gives me here the 'highest' datetime that is found .. regardless of the user.

What i want is the Peek of NetDateTime where the user is equel to the user of the current record that is loaded

Thanks in advanced

[prieper]

You need to get a sorting into it and check for your condition. Script may look like

NetDateTime,
IF(User = PEEK(User), PEEK(NetDateTime)) AS Peek,
User
FROM ...
ORDER BY
User ASC,
NetDateTime DESC;

HTH
Peter