Search results
-
H
select 2 fields from 2 table and combining into 1 table
i wan to get two Time rows from two tables. one row displaying the start time which is Event 528 and one row displaying the end time which is event 551.. how do i join the 2 tables? -
H
select 2 fields from 2 table and combining into 1 table
i added in Newlog.Event but its the same... -
H
select 2 fields from 2 table and combining into 1 table
this is my sql SELECT Newlog.Computer, Newlog.Date, Newlog.User, Newlog.Time, Newlog2.Time, Newlog2.Event FROM Newlog, Newlog2 WHERE Newlog.Event=528 And Newlog2.Event=551; i want to select newlog.time according to the newlog.event=528 and newlog2.time according to newlog2.event=551 but it... -
H
convert time to seconds
hi Wayne, i tried renaming the field.. here's my SQL SELECT Newlog.Timer, DateDiff("s",Date() & " 00:00:00 AM",Date() & [Newlog.Timer]) FROM Newlog; but it still returns an error.... -
H
convert time to seconds
the results display beside the time field shows #Error... -
H
convert time to seconds
SELECT Newlog.Time DateDiff("s",Date() & " 00:00:00 AM",Date() & [Newlog.Time]) FROM Newlog; my sql statement is this but i get a syntax error (missing operator) in query expression 'Newlog.Time DateDiff("s",Date() & " 00:00:00 AM",Date() & [Newlog.Time])' how do i modify it? -
H
convert time to seconds
how do i convert my time field 3:11:07 PM to seconds using microsoft access query sql?