Roger's Access Library Homepage
Forum Home Forum Home > Other Download Libraries > MS Access MVP Libraries > Tejpal, A.D.
  New Posts New Posts RSS Feed - RunningCountSum_2K.mdb
  FAQ FAQ  Forum Search   Events   Register Register  Login Login


Please consider donating $1 per sample downloaded, (find out why here)

RunningCountSum_2K.mdb

 Post Reply Post Reply
Author
Message
A.D. Tejpal View Drop Down
Microsoft MVP
Microsoft MVP


Joined: 30 Jun 2008
Status: Offline
Points: 192
Post Options Post Options   Thanks (0) Thanks(0)   Quote A.D. Tejpal Quote  Post ReplyReply Direct Link To This Post Topic: RunningCountSum_2K.mdb
    Posted: 06 Jul 2008 at 11:01pm
This database covers display of running count and  sum of records on continuous
forms. Two alternative methods are demonstrated -
    Method A (Form Based) -
        Values are computed locally in calculated controls on the form. There is no
dependence on any primary key or particular sort order. (Records Remain Editable)

    Method B (Query Based) -
        Values are computed in the source query. Though primary key is required,
there is no compulsion to sort on it (Records Remain Editable)
    Note - Typically, record counter in a query involves use of either a subquery or
DCount function. Both require (i) A primary key  and  (ii) Sorting to be in force - on
the primary key field. This can pose a limitation where main sorting is desired on a
field other than that holding primary key. Moreover if subquery method is used, the
records are no longer editable.
    The sample database is free from such limitations

Version - Access 2000
       References -
            Visual Basic For Applications
            Microsoft Access 9.0 Object Library
            OLE Automation
            ADO 2.6
            DAO 3.6

Download Access 2000: uploads/37/RunningCountSum_2K.zip

--

Email: adtejpal@gmail.com
Back to Top
Sponsored Links


Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down