Physimed
asked on
MS Access, VBA : How to use the SUM function on Unbound field in a report?
Hi,
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?
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?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
At least we know that it can't be done with the SUM function.
We have finished our report and our sum are now calculated through VBA Code.
Thanks again.
JS