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


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

Query_ComputeAsPerRulesTable.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: Query_ComputeAsPerRulesTable.mdb
    Posted: 08 Jul 2008 at 10:16pm
This sample db demonstrates computations as per formulae existing in a dedicated separate table.

Three alternative styles are covered:
        (a) Permanent Query utilizing user defined function for the computations. The
             results are spread across records.
        (b) Dynamically generated query - Results spread across columns.
        (c) Dynamically generated query - Results spread across records.

Report based upon 4.2(a) above, is also included.
    
Versions - Access XP (in Access 2000 File Format)
References - DAO 3.6

Download Access XP: uploads/37/Query_ComputeAsPerRulesTable.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