Simple sums in Access Forms question

Dana_19

Commendable
Jun 14, 2016
1
0
1,510
0
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.
 

Ralston18

Dignified
Moderator
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.

 

Ralston18

Dignified
Moderator
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.

 
Thread starter Similar threads Forum Replies Date
S Apps General Discussion 5
A Apps General Discussion 2
P Apps General Discussion 2
G Apps General Discussion 0
gigaman Apps General Discussion 1
B Apps General Discussion 6
drjackool Apps General Discussion 5
G Apps General Discussion 4
S Apps General Discussion 2
Achint2000 Apps General Discussion 4
J Apps General Discussion 2
C Apps General Discussion 3
Pimpom Apps General Discussion 5
P Apps General Discussion 1
P Apps General Discussion 6
T Apps General Discussion 1
giantbucket Apps General Discussion 2
L Apps General Discussion 1
V Apps General Discussion 8
B Apps General Discussion 3

ASK THE COMMUNITY

TRENDING THREADS