Sum in Access -

Mbime - Mar 17, 2015 at 09:59 AM
please can someone guide me on formula in access. i want to achieve the below result which I've done in excel - but now I want the same in access.
group totals add all the group figures.
Variances = Group totals-in stock.
please the same in access Please.

In Stock Group-01 Group-02 Group-03 Group-04 Group-05 Group Totals Variances
4600 600 650 560 400 450 2660 (1,940)