Query_ComputeAcrossFields_CodeLess

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   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 >>:  uploads/37/Query_ComputeAcrossFields_CodeLess.zip

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
A.D. Tejpal Members Profile Send Private Message Find Members Posts Add to Buddy List Microsoft MVP Joined: 30 Jun 2008 Status: Offline Points: 192	Post Options Post Reply Quote A.D. Tejpal Report Post Thanks(0) Quote Reply Topic: Query_ComputeAcrossFields_CodeLess 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 >>: uploads/37/Query_ComputeAcrossFields_CodeLess.zip
	-- Email: adtejpal@gmail.com

Sponsored Links