Simple sums in Access Forms question

Dana_19

Commendable
Jun 14, 2016
1
0
1,510
I simply want to show a table on an Access form that displays sums for each of the rows of fields and sums for each of the columns of fields. It will appear as a table with sums along the right side and sums across the bottom, and a grand total in the bottom right corner. Is this possible? I cannot figure this out.
 
Solution
Look into Crosstab Queries.

Do not know your data structure but a CrossTab query may get things going and then you may be able to present the results in a report or form.

The report or form could in turn, finish up any remaining sums, totals, grandtotals, etc..

Or pass the data to Excel table and link to that structure for crosstab tallies.

Look into Crosstab Queries.

Do not know your data structure but a CrossTab query may get things going and then you may be able to present the results in a report or form.

The report or form could in turn, finish up any remaining sums, totals, grandtotals, etc..

Or pass the data to Excel table and link to that structure for crosstab tallies.

 
Solution