Transpose fields into data

[milesada]

I've got a table with a structure of:

BuildingID PersonId Value1 Value2 Value3
123 001 564 1 952
123 002 122 36 512


What I need to do is transpose the values thusly:

BuildingId PersonId ValueId ValueValue
123 001 1 564
123 001 2 1
123 001 3 952
123 002 1 122
123 002 2 36
123 002 3 512

There's 96 values for each PersonId, so a way to do this automatically/programatically would make my life much easier! Thanks in advance!

 

[Bastien]

Hi
In the tables section, index the field that you want, PersonID in this case. Click on the index button in the design view and follow the wizard, no coding needed and values are automatically sorted whenever there is a new entry...

hth

Bastien

There are many ways to skin this cat,
but it still tastes like chicken