i got problems in query out the recods from the database access.



in the database access, i have these 2 records

RequestID    WhenRequested         EmpName         Dept        Shift   

217           10/9/2001 12:44:06AM Hou Tai Siong  PRODUCTION    MORNING

FromTime   ToTime    Purpose   Line Status

1800         1830    OT       5     Pending



RequestID    WhenRequested    EmpName        Dept               Shift

218            10/9/2001 12:44:06AM   AH loong  Production    MORNING

FromTime    ToTime    Purpose   Line Status

1800            1830    OT       5    Pending





i use this code to quary out the records:



set RSRequestID = conn.Execute("select RequestID from HROTRequest where " &

_

"WhenRequested = #" & CurrentDateTime & "#")



strET = strET & "Use this link to Accept Request : " & "

" & _ "" & _

"http://192.168.168.6/OT/html/decision.asp?Action=Yes&RequestID=" &

RSRequestID("RequestID") & "

" & _ "Use this link to Reject Request:" & "

" & _ "" & _

"http://192.168.168.6/OT/html/decision.asp?Action=No&RequestID="

&RSRequestID("RequestID") & "

"



set RS = conn.Execute("select EmpName, Dept,Shift, FromTime, ToTime,

TheTotal, Purpose, Line from HROTRequest where " & _

"WhenRequested = #" & CurrentDateTime & "#")







my questions:



1) I found that only the first record been query out. How can i query all

the records with same DateTime from the Access database?



please assists



hoay fern