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 - MatchCombinations_2K.mdb
  FAQ FAQ  Forum Search   Events   Register Register  Login Login


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

MatchCombinations_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: MatchCombinations_2K.mdb
    Posted: 08 Jul 2008 at 10:34pm
This is an exercise in matching largest possible combinations of positive and 
negative values for a given field in the database so that their values offset each 
other. This information is relevant to certain systems of book keeping.
In order to achieve best results, at the same time avoiding unaffordable slowing 
down in processing each and every possible combination (the number of 
theoretically possible combinations can become astronomically huge as the total 
number of records in the database increases), following sort sequence is adopted 
for positive and negative values before computing their running sums, which in turn 
are subjected to cartesian comparison -
    (a) Pos Asc,         Neg Asc
    (b) Pos Asc,         Neg Desc
    (a) Pos Desc,       Neg Asc
    (a) Pos Desc,       Neg Desc
    (a) Pos Random, Neg Random

Download Access 2000: uploads/37/MatchCombinations_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