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: 20 Jan 2021 at 8:35am
Software Version: Web Wiz Forums 12.03 -

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

Forum Software by Web Wiz Forums® version 12.03 -
Copyright ©2001-2019 Web Wiz Ltd. -