Access should be able to total selected datasheet ranges like exce

G

Guest

Excel has a nice status bar feature showing totals (plus averages, min/max
and more) for selected ranges.

It would be useful to have this same feature in Access when in a datasheet
view. This would calculate over selected columns, rows, or ranges.

I did this in code once and applied it to the appropriate drop down menus.
But it was kind of a pain to distribute and didn't calculate large sets of
numbers correctly.


----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...-b12a-4e071d83a80e&dg=microsoft.public.access
 
J

Joseph Meehan

mkincaid said:
Excel has a nice status bar feature showing totals (plus averages,
min/max and more) for selected ranges.

It would be useful to have this same feature in Access when in a
datasheet view. This would calculate over selected columns, rows, or
ranges.

I did this in code once and applied it to the appropriate drop down
menus. But it was kind of a pain to distribute and didn't calculate
large sets of numbers correctly.

Consider using a query.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top