|
Posted by teddysnips on 12/05/05 11:52
MC wrote:
> Here si one way of doing it.
>
> SELECT *
> FROM tblTest
> WHERE
> fldCLocktime = (select max(ClockTime) from tblTest where clocktime <
> '02/01/2005 12:34' and fldEmployeeID = 1)
> AND
> fldEmployeeID = 1
Hi MC
Your response put me onto another way that doesn't use a sub-query:
SELECT TOP 1 *
FROM tblTest WHERE fldClocktime <
'02/01/2005 12:34' and fldEmployeeID = 1
ORDER BY fldClocktime DESC
Both methods work fine - thanks for your help.
Edward
Navigation:
[Reply to this message]
|