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: 18 Nov 2018 at 1:11am

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

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

Print Page | Close Window