Search results

  1. 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...
  2. H

    convert time to seconds

    how do i convert my time field 3:11:07 PM to seconds using microsoft access query sql?
Back
Top Bottom