RunningCountSum_2K.mdb |
Post Reply |
Author | |
A.D. Tejpal
Microsoft MVP Joined: 30 Jun 2008 Status: Offline Points: 192 |
Post Options
Thanks(0)
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 |
|
Sponsored Links | Want a good read? Try The Summer of His Life (available on Amazon!) |
Post Reply | |
Tweet
|
Forum Jump | Forum Permissions You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |