Hello Everybody,
Can someone help please? I have started to create a report which will be a client monthly account. I have embedded a sub-report on it for work carried out during the month. The common field is customer code (cuscode). The report and sub-report are grouped therefore by cuscode and I'm working on forcing a page break after each cuscode group.
I understand that I need to generate a total in the sub-report footer and I've seen it on a Youtube tutorial and a description on The Microsoft Office \ Access help site. I can't get it to work and so I can't move forward to passing it to the main report.
The line total on the work sub report is a calculated control called 'TotJobRetail' with the expression =[RetailMats]+[HrsValue]+[CashOutNoProfit]
The line totals are calculated correctly.
On the footer I have tried =Sum([RetailMats]+[HrsValue]+[CashOutNoProfit]) which as far as I can see should do the trick.
If anyone can help, please be aware that I am still very new to Access so please explain in as much detail as you can.
Thanks.