Access 2007 Total Row?

A

Al Franz

This has worked before so not sure what is wrong. I open up a table, press
the Total Summation button and a TOTAL row is created at the bottom of the
table. But I thought I should be able to click on the total boxes and
select what value I want such as a total, avg, etc. It currently is not
bringing anything up to select, I just see a Total row with no values?
 
A

Al Franz

Not sure what you mean. I call up a table then click on the summation
TOTALS button. I get a TOTALS row but when I click on the blank cells in
the totals row nothing happens, I don't see a drop down??
 
A

Arvin Meyer [MVP]

You should not be able to select a totals row in a table, only in a query.
In a query, you should see the Sigma (summation button) and you should then
get a row labeled:

Total

The contents of that row are initially set to:

Group By

By clicking on one of the Group By values, you should be able to change that
to another aggregate type, like Count or AVG. If you cannot do that, there
is something wrong with your Access installation and you need to redo it.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com
 
B

Brendan Reynolds

Arvin Meyer said:
You should not be able to select a totals row in a table, only in a query.
In a query, you should see the Sigma (summation button) and you should
then get a row labeled:

Total

The contents of that row are initially set to:

Group By

By clicking on one of the Group By values, you should be able to change
that to another aggregate type, like Count or AVG. If you cannot do that,
there is something wrong with your Access installation and you need to
redo it.
Click to expand...


There's a Totals feature in tables in Access 2007, Arvin. Might be available
in the new ACCDB format only, not sure about that. The choices available
seem to vary depending on the data type of the column, e.g. in a text column
I get "None" and "Count", in a numeric column I get "None", "Average",
"Count", "Maximum" and "Minimum".
 
A

Arvin Meyer [MVP]

There's a Totals feature in tables in Access 2007, Arvin. Might be
available in the new ACCDB format only, not sure about that. The choices
available seem to vary depending on the data type of the column, e.g. in a
text column I get "None" and "Count", in a numeric column I get "None",
"Average", "Count", "Maximum" and "Minimum".
Click to expand...

It probably is only available in the new format, which I have no need for
and do not use. I NEVER use tables for anything but storing data, and I
NEVER let users even see the tables directly. It is a very bad practice for
many reasons, but chief amongst them are security and accidental deletion of
lots of data.

I once had the comptroller of the company I worked for delete more than
12,000 buyers' names, thinking she was using a spreadsheet, and it would be
OK if she didn't save. Obviously, it wasn't. I was on vacation without a
computer and the company had to call me back to fix it, since restoring from
a backup would have cost a day's data. Fortunately, I recovered all but 1
row and was able to call a sales person who had a hard copy of that person's
information. I was then able to manually change the related foreign keys.

The point is that tables are like the registry, only gurus and fools go
there. There is nothing that can't be done better somewhere else.
 
Top