Welcome to the Sage VIP Classic and Sage VIP Premier Support Group on Community Hub! Available 24/7, the forums are a great place to ask and answer product questions, as well as share tips and tricks with peers, partners, and pros.
Hi all
I am trying to create a summary for all overtime hours paid per department in EM HR - I have created the following:
1. SQL Query
SELECT
SRV_0 ,ISNULL(OT,0) ,ISNULL(OTWKD,0) ,ISNULL(PH,0) ,'' ,'' ,'' ,''
FROM ZTCHCECK
GROUP BY SRV_0…