Print Page | Close Window


Printed From: Roger's Access Library
Category: Other Download Libraries
Forum Name: Tejpal, A.D.
Forum Description: A.D. Tejpal's Library
Printed Date: 21 Mar 2018 at 4:02am

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: -

Print Page | Close Window