Hello,
meron po ako na may 3 fields
Sa Button Start ko po,
Sa button end ko po,
For example po ay ganito:
Thanks in advance mga boss!
meron po ako na may 3 fields
Code:
Start_Time - (DateTime) - default value nya po is =Now()
End_Time - (DateTime) - default value nya po is =Now()
Time_Lapse - (DateTime) - default value nya po is =Now()
Sa Button Start ko po,
Code:
"UPDATE tbl_Logged SET Start_Time =#" & Now() & "# WHERE Rep_ID = " & RepID &""
Sa button end ko po,
Code:
"UPDATE tbl_Logged SET Eend_Time =#" & Now() & "#,[B][COLOR="#B22222"]Time_Lapse= "GUSTO KO PO MAKUHA UNG TIME DIFFERENCE NUNG START TIME AT END TIME"[/COLOR][/B] WHERE Rep_ID = " & RepID &""
For example po ay ganito:
Code:
Start Time = 02/12/2015 10:30:00 PM
End Time = 02/13/2015 01:30:00 AM
Time Lapse = 03:00:00
Thanks in advance mga boss!
Last edited: