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/comm....public.access

mkincaid wrote:
> 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.

>
>
> ----------------
> 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/comm....public.access

--
Joseph Meehan

Dia duit