Tejpal, A.D. - RunningCountSum

Print Page | Close Window

RunningCountSum_2K.mdb

Printed From: Roger's Access Library
Category: Other Download Libraries
Forum Name: Tejpal, A.D.
Forum Description: A.D. Tejpal's Library
URL: www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=36
Printed Date: 19 Apr 2024 at 2:24pm
Software Version: Web Wiz Forums 12.03 - http://www.webwizforums.com

Topic: RunningCountSum_2K.mdb

Posted By: A.D. Tejpal
Subject: RunningCountSum_2K.mdb
Date 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: http://www.rogersaccesslibrary.com/forum/uploads/37/RunningCountSum_2K.zip -