Recent content by Access_Elic

  1. A

    Text to Time Query

    Hi Guys, Hi guys currently I have query from text to time, I used the query below, and the output is 8:00:00 AM I want to remove the seconds and Retain the AM/PM. timein: Min(CDate(Mid(HISTORY.ETIME,1,2) & ":" & Mid(HISTORY.ETIME,3,2)))
  2. A

    Time and Attendance Project

    Thank you namliam for prompt response, and it worked stupid of me. I have another question How can I combined two columns Like Transaction Date and Time IN.
  3. A

    Time and Attendance Project

    Hi Guys, Currently we a door access and all the data I downloaded from the device is text, First problem the Time IN datatype is text I want to convert it to DATE/TIME data type and it should be First IN (MIN). I tried the query below I have an error. Syntax Error Missing Operator...
  4. A

    Hello Access World

    Hi, I am new in access and I have project hope you guys can help me.
See more
Back
Top Bottom