Sum does not work in Form Footer in Access 2007 - Microsoft Community

I am setting up a stock database with data in a back end on the server and 3 slightly different front-ends. All 3 have a main Form footer summarising stock as filtered in the form.

answers.microsoft.com