Well, I dont remember it being a piece of cake ever - stackoverflow
. Cannot say for MSAccess.
The common solution is data oriented and possibly can be used with the enduser designer... Assembly with a model, having all relations (and custom totals). Then bindings to the linking collections - forum link
The only coding will be the model, but it will be useful elsewhere.