Totals

[Evagrius]

Hello - using Access 2010.

I have a select query. Column one is "Zone", Column two is "Sales", and Column three is "Sales Goal". Column two and three are currency. Column four is a division of column two and three - so "sales" / "sales goal". So column four is a percentage.

Where I need help is I included the Totals as the bottom of the query. But the totals also sums the entire percentage column . .what I really would like to divide the totals . .not sum the percentages . . I hope that makes sense . .

Thank you for any help . .

 

[arnelgp]

use "Expression" on your Total row of your query design.

 

[Evagrius]

arnelgp - I am sorry - I am not sure that you are directing? Can you please be more specific?

 

[AlexN]

Hello - using Access 2010.

I have a select query. Column one is "Zone", Column two is "Sales", and Column three is "Sales Goal". Column two and three are currency. Column four is a division of column two and three - so "sales" / "sales goal". So column four is a percentage.

Where I need help is I included the Totals as the bottom of the query. But the totals also sums the entire percentage column . .what I really would like to divide the totals . .not sum the percentages . . I hope that makes sense . .

Thank you for any help . .

What arnelgp suggests is that you you keep "Group by" in the Totals Row of your query design, in all columns, except column 'Sales' and 'Sales Goal' where you use 'Expression'.

 

[Evagrius]

I am sorry - please be patient. In the query in Datasheet view, the very last row, should sum all the above rows, but not sum the last column with percentages. Instead, I would like to divide the last row with sales by sales goals . .

 

[AlexN]

I am sorry - please be patient. In the query in Datasheet view, the very last row, should sum all the above rows, but not sum the last column with percentages. Instead, I would like to divide the last row with sales by sales goals . .

I'm afraid you got it all wrong. There is no 'very last row' in a query. Totals appear in specified columns. Take a look here --> http://www.599cd.com/tips/access/aggregate-query/

 

[Evagrius]

Ahh - - I see - thank you AlexN for clearing my confusion.