In the tutorial, the very first example, titled Merge Records By Category, provides the 'simple' solution. From there it builds ever more complex solutions, including solutions that address your need. All it takes is the time to read and apply. The hard work - the field coding - has all been done for you.
The DATABASE field examples that are linked to in those threads show yet another way of achieving the same end, as do the links to the 'Many to One' utilities.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
|