This problem has been haunting us for a while. Let me explain the scenario:
We are doing a REPORT that will calculate the total time use for a job in a month.
January 30 min
February 45 min
Total 75 min
Each month time is populated through VBA code on the ON FORMAT of the section. (searching the right compagny, the right employee and other criterias)
Then when we try to use the SUM function on the control source of the sumOfTemp field nothing gets calculated.
We do not have problem using the SUM function when our report is populated dirrectly through a table.
Do you have any ideas on how we can make this work?