Print Page | Close Window

Query_ComputeAcrossFields_CodeLess

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=565
Printed Date: 13 Dec 2017 at 3:34pm


Topic: Query_ComputeAcrossFields_CodeLess
Posted By: A.D. Tejpal
Subject: Query_ComputeAcrossFields_CodeLess
Date Posted: 15 Jun 2011 at 12:13am

Query_ComputeAcrossFields_CodeLess
Explanatory Notes

    This sample db demonstrates computations across fields via pure SQL. In the first step, normalization of data is accomplished, using Cartesian join between the source table and an ancillary single field table holding the field names. Thereafter, a totals query provides the desired results.

    Two styles are covered:
    (a) Compute across all fields.
    (b) Compute across top 3 fields (i.e. fields holding top 3 values).

Version:  Access 2000 File Format

Reference:  Nothing Extra

Download File >>:  http://www.rogersaccesslibrary.com/forum/uploads/37/Query_ComputeAcrossFields_CodeLess.zip -



Print Page | Close Window