By A.D. Tejpal
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
You can find the sample here:
http://www.rogersaccesslibrary.com/forum/query-computeacrossfields-codeless_topic565.html
No comments:
Post a Comment