Summing the values in a column

[silarri]

Hi everybody,

is there some easy way to add all the values of a column of a table (to
get the total) returned by a query and show it on the same page (to
print it)? I am interested in doing something similar to the reports
you can do with other tools such as Microsoft Works.
Thanks in advance,

Sergio

 

[Guest]

If you are thinking of a total row like a spreadsheet - I'm afraid not.

If all you want is the sum of a field, then create a "sum" query from your
table.

Drag only the feids you will group and sum to the query grid.
Click on totals button ( The summation Icon )
On the totals row of the grid, make sure sum is selected for the field you
want totaled, and Group by is selected for the other fields.

The easiest thing is to create a report from your query/table that has
grouping you want , and you can add a totals controls int the footers of the
report.

Rosco

 

[ôë]

If you are thinking of a total row like a spreadsheet - I'm afraid not.

If all you want is the sum of a field, then create a "sum" query from your
table.

Drag only the feids you will group and sum to the query grid.
Click on totals button ( The summation Icon )
On the totals row of the grid, make sure sum is selected for the field you
want totaled, and Group by is selected for the other fields.

The easiest thing is to create a report from your query/table that has
grouping you want , and you can add a totals controls int the footers of the
report.

Rosco