Grand total in report won't total (with screenshots)
Sorry to post this a second time (first time referenced here):
but I needed to add screenshots and could only remember how to do this from a thread starting post - answers seem unable to do this? Anyway, here are the diagrams which I hope explain my position better than I can.
Basically, I can't get a report to work that takes values from more than one table. I have tried more than one method (the last one used Calc fields from Client2 as Grand Totals in the report, but this didn't work either), so I've pared this down to the basic question I want to show - and it also doesn't work.