Text to Time Query

[Access_Elic]

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)))

 

[Big Pat]

Does your output actually function as a time, or is it just text that LOOKS like a time? If it's really a time (CDATE makes me think it is) you could try:
Right-click the query column > select Properties > Format > "medium time".