This: VERIFYTIME is not an actual field in the tables. Therefore it can not be used in this way, you will need to duplicate the way you generate that there
Code:sum(DATEDIFF('M',ENDTIME,STARTTIME)) as VERIFYTIME, (TotalKS/sum(DATEDIFF('M',ENDTIME,STARTTIME)))*60 as KSHR




Reply With Quote