sub queries

[waqas]

Dear Experts,i am trying to count OFF, Sick leave, Annual leave in seprate columns using sub queries but it become slow and when i scroll down the it is hangedcan someone tell me how to write query are a different method to do same.SELECT TblTimeSheetTest.IDNUM, Format([SDay],"mmm") AS Mnth, Sum(TblTimeSheetTest.NHrs) AS SumOfNHrs, Sum(TblTimeSheetTest.OTHrs) AS SumOfOTHrs, Sum(TblTimeSheetTest.PreHrs) AS SumOfPreHrs, Sum(TblTimeSheetTest.TotalHrs) AS SumOfTotalHrs, (SELECT count(offalias.tanda) from tbltimesheettest as offalias where offalias.tanda = "OFF" and offalias.idnum = tbltimesheettest.idnum) AS OFF, (SELECT count(offalias.tanda) from tbltimesheettest as offalias where offalias.tanda = "Sick Leave" and offalias.idnum = tbltimesheettest.idnum) AS SL, (SELECT count(offalias.tanda) from tbltimesheettest as offalias where offalias.tanda = "Annual Leave" and offalias.idnum = tbltimesheettest.idnum) AS ALFROM TblTimeSheetTestGROUP BY TblTimeSheetTest.IDNUM, Format([SDay],"mmm");

[orange]

The references often cited as the authority on subqueries is Allen Browne's material.

http://allenbrowne.com/subquery-01.html
http://allenbrowne.com/subquery-02.html

Good luck