Data Type Mismatch in criteria expression.
SELECT Count(tblTimeLog.LogDate) AS CountOfLogDate, tblTimeLog.EM_ID, tblTimeLog.NAME, tblTimeLog.TimeIn, tblTimeLog.TimeOut, tblTimeLog.E_ARRIVAL, tblTimeLog.L_DEPT, tblTimeLog.L_IN, tblTimeLog.E_DEPT, tblTimeLog.HOLIDAY_IN, Sum(tblTimeLog.OT) AS SumOfOT, Sum(tblTimeLog.LATE) AS SumOfLATE, tblTimeLog.REMARK
FROM tblTimeLog
GROUP BY tblTimeLog.EM_ID, tblTimeLog.NAME, tblTimeLog.TimeIn, tblTimeLog.TimeOut, tblTimeLog.E_ARRIVAL, tblTimeLog.L_DEPT, tblTimeLog.L_IN, tblTimeLog.E_DEPT, tblTimeLog.HOLIDAY_IN, tblTimeLog.REMARK;
I had tried this Above query to get the sum value of tblTimeLog.OT & tblTimeLog.LATE which are in text field but i get this error. (Data Type Mismatch in criteria expression) please help to find the mistake and the solution. Thank You
Re: Data Type Mismatch in criteria expression.
You can't sum text fields.
Either redesign your table or put conversion function in the query