Collasping fields

[Ellen]

Hello,
I have multiple fields of the same information I'd
basically like to collaspe into the same field. Let me
illustrate with two sample records containing three
fields, where I'd like field2 and field3 to collapse into
single field:

IDfield: 123 field2: information1 field3: information2
IDfield: 345 field2: information3 field3: information4

becomes four records with two fields:

IDfield: 123 field2:information1
IDfield: 123 field2:information2
IDfield: 345 field2:information3
IDfield: 345 field2:information4

I actually have 9 fields I'd like collapsed into one, so
my number of records should increase by a factor of nine.

Thanks in advance.

Ellen

 

[Roger Carlson]

On my website (see sig below) is a small sample database called
"NormalizeDenormalize.mdb" which shows one way to do this.

 

[Guest]

Thank you Roger. I've
downloaded "NormalizeDenormalize.mdb". I've found the
modules. Now how do I execute them? Where is the execute
button?

Thanks in advance.

Ellen