[MS ACCESS] Time Difference Query

[k0piko]

Hello,

meron po ako na may 3 fields

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,

"UPDATE tbl_Logged SET Start_Time =#" & Now() & "# WHERE Rep_ID = " & RepID &""

Sa button end ko po,

"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:

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!

 

[rhon6260]

Hello,

meron po ako na may 3 fields

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,

"UPDATE tbl_Logged SET Start_Time =#" & Now() & "# WHERE Rep_ID = " & RepID &""

Sa button end ko po,

"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:

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!

Search mo DATEDIFF

 

[k0piko]

Search mo DATEDIFF

cmd.CommandText = "SELECT DATEDIFF(Minute,Date_Assign,Date_Completed) AS Time_Elapse FROM tbl_Grade WHERE G_ID = " + this.txt_G.text + "";

No value given for one or more required parameters sir.