Sum/Avg on the fly - Status bar?

ppataki

Registered User.
Local time
Today, 08:42
Joined
Sep 5, 2008
Messages
267
Dear All,

I would have a "strange" question:

Is it somehow possible in Access to display the sum, avg...etc of certain selected "cells"?
Just like in Excel if you select certain cells it gives you the sum, avg etc down in the Status bar - so is it possible to add a Status bar, or similar thing in Access?

Many thanks in advance ;)
 
Access does indeed have a status bar which is not tied to any particular form.

Use the status bar text property to display information to the user.
 
Can you please tell me how I can use that to display the sum of selected cells on the screen?

Many thanks
 
As Dennisk stated Access can display an ActiveX status bar on the bottom of a form. However the contents of the panels are programmable and as such do not act dynamically, apart from date and time functionality. You would need to create seperate panels for each Sum, Avg, etc and somehow get Access to a) determine howmany, if any, records have been selected in your sub/continuous form. and then which formulae to apply.

Access is Access = Excel is Excel
 

Users who are viewing this thread

Back
Top Bottom