Hi
I have created a MS access table which captures the attendance for the employee. In the table , the field IOTime carries the time of the associate entry.
I have written an SQL query to fetch the data for the current date . but i am unable to get the records for specific time.
Can anyone help me with the syntax:
here is my code:
SELECT IOData.CardNo, IOData.IODate, IOData.IOTime, IOData.IOStatus
FROM IOData
WHERE IODate=Date()
The above code get the record that contains the IODate value as current date. Same way i need to get the IOTime for current time.
Thanks in advance
isihalin
I have created a MS access table which captures the attendance for the employee. In the table , the field IOTime carries the time of the associate entry.
I have written an SQL query to fetch the data for the current date . but i am unable to get the records for specific time.
Can anyone help me with the syntax:
here is my code:
SELECT IOData.CardNo, IOData.IODate, IOData.IOTime, IOData.IOStatus
FROM IOData
WHERE IODate=Date()
The above code get the record that contains the IODate value as current date. Same way i need to get the IOTime for current time.
Thanks in advance
isihalin