Tejpal, A.D. - Query_ComputeAsPerRulesTable.mdb

Print Page | Close Window

Query_ComputeAsPerRulesTable.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=66
Printed Date: 19 Apr 2024 at 4:53pm
Software Version: Web Wiz Forums 12.03 - http://www.webwizforums.com

Topic: Query_ComputeAsPerRulesTable.mdb

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