Total Row at the bottom of a query

[YNWA]

Hi,

Is it possible to return a query with a selection of fields in and at the bottom a total row with a sum of 1 fields amounts?

All to appear in the 1 query?

Thanks

 

[pbaldy]

Sure, with a union query. Along these lines:

http://www.rogersaccesslibrary.com/forum/topic60.html

 

[Pat Hartman]

You wouldn't normally want to do this in a query. If you do it in a query, you need to make sure that your "totals" row is distinguishable from all the other rows and will ALWAYS sort to the end.

A better method would be to create the totals on a form or report. If you are using A2010, Access has a new feature that lets you define a totals row at the bottom of a form in datasheet view. Look for the little sigma button in the ribbon.

 

[YNWA]

You wouldn't normally want to do this in a query. If you do it in a query, you need to make sure that your "totals" row is distinguishable from all the other rows and will ALWAYS sort to the end.

A better method would be to create the totals on a form or report. If you are using A2010, Access has a new feature that lets you define a totals row at the bottom of a form in datasheet view. Look for the little sigma button in the ribbon.

Cheers pal.

I am thinking the same as you using a report but I will see what this form looks like.

Thanks.

 

[AGAL]

I share a table with <10 users.

I tried to use the Sigma Totals button in the ribbon on the table view. I am so confused because on another colleague's and my access table the sum function is working properly.

However, there are 2 other reported users who can not see the total. They can toggle the button and the row appears, but the total will not calculate. It is the same table, I just dont understand.

Any advise?