Report Header and Footer
I have a report in access where it calculates earnings and getting total amount of earnings.
The last column - earnings: Control Source is =[flatrate]+[HourlyTotal] and Name is earnings.
There is no problem with this. It displays the results fine. The problem is with
The control that is supposed to add up all the numbers in "earnings" is Sub Total and its Name and Control Source is as shown above.
When I run this report, as it is "=Sum([earnings])", it prompts me to enter the value for "earnings". But if I replace "=Sum([earnings])" with "[earnings], then it runs the report but it only displays the value of earnings field from the last record, instead of total of all earnings.
Can you help?