Tejpal, A.D. - Query_ComputeAcrossFields

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: 18 Apr 2024 at 9:21pm
Software Version: Web Wiz Forums 12.03 - http://www.webwizforums.com

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 -