Hi team,
I am having a table with three fields named Empname, Wdate and totalhrs. I am also having a form with same names. When I choose empname and date in form the third field has to show the sum of totalhrs. Since the totalhrs has the chances of having a time more than 24 hrs. The sum query which I use is not showing correct result. I did try few changes in the sql query which I have but it yielded no results. Could you assist?
I am having a table with three fields named Empname, Wdate and totalhrs. I am also having a form with same names. When I choose empname and date in form the third field has to show the sum of totalhrs. Since the totalhrs has the chances of having a time more than 24 hrs. The sum query which I use is not showing correct result. I did try few changes in the sql query which I have but it yielded no results. Could you assist?