![]() |
Please consider donating $1 per sample downloaded, (find out why here) |
Query_ComputeAcrossFields_CodeLess |
Post Reply ![]() |
Author | |
A.D. Tejpal ![]() Microsoft MVP ![]() Joined: 30 Jun 2008 Status: Offline Points: 192 |
![]() ![]() ![]() ![]() ![]() Posted: 15 Jun 2011 at 12:13am |
Query_ComputeAcrossFields_CodeLess 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: Version: Access 2000 File Format Reference: Nothing Extra Download File >>: uploads/37/Query_ComputeAcrossFields_CodeLess.zip
|
|
![]() |
|
Sponsored Links | |
![]() |
Post Reply ![]() |
|
Tweet
|
Forum Jump | Forum Permissions ![]() You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |