|
Denormalize.mdb (intermediate) |
||||
Please consider donating $1 per sample downloaded, find out why here |
Download Denormalize.zip Access 97 (32 KB) |
Assume the tables below: Denormalize takes the data in table1 and creates table2. Thus it denormalizes a normalized table. This has 4 subs/functions. "DenormalizeTable" is the main sub which calls the others. "CreateDenormalizedTable" deletes and re-creates table2. It calls "MaxNumberOfFields" to decide how many fields to create. Lastly, "DenormalizeIt" does the denormalization. To execute it, go the module, put your cursor in the first sub, and push the execute button. TABLE1 ID Value 1 10 1 20 2 30 2 40 2 50 2 60 2 70 3 80 3 90 4 100 TABLE2 ID Value1 Value2 Value3 Value4 Value5 1 10 2 30 40 50 60 70 3 80 90 4 100 |
||||
|
|||||
|
|||||