Calculation hours

[ultra5219]

hello
i wana ask about calculation hours for schedule table. lets say how to calculate based on what i select from my schedule table for :
no class: how many hrs
lesson i got class: how many hours.. for example: 1+0.5= 1.5 hrs
total of hours: which is based on "no class" + " lesson i got class" for example: 1+1+0.5= 2.5 hrs

Thanks..

 

[billmeye]

I've updated your report to include the calculations. Take a look and you will see it is first checking to see if it is No_Class and then it is pulling in the actual hours for the time slot from your time_hrs query, and finally summing up the total hours for your report.

So, there are 3 steps:

If statement determines if you want hours or 0
Dlookup finds out how many hours are in your time period
Sum adds up how many hours to display.

 

[ultra5219]

I've updated your report to include the calculations. Take a look and you will see it is first checking to see if it is No_Class and then it is pulling in the actual hours for the time slot from your time_hrs query, and finally summing up the total hours for your report.

So, there are 3 steps:

If statement determines if you want hours or 0
Dlookup finds out how many hours are in your time period
Sum adds up how many hours to display.

Thank You!! finally solved!!
oh yea.. the DLookup which search hours many hours based what i select for time schedule right?