Hi Lisa,



Perhaps I'm missing something, but it seems to me your 'would like' format contains none of the before/after text and merely needs to use the tutorial's 'Merge Records by Category Using Two Keys' example, perhaps with some minor reformatting.

As for documentation of field code syntax, there isn't much available but see:
http://office.microsoft.com/en-us/wo...102110133.aspx?
http://office.microsoft.com/en-us/wo...101830917.aspx

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

True - my "would like" was only showing the repeating data, not the formatting that would be needed. When I was beginning I was only trying to master the repeating data. The formatting would come later to make it more presentable.

Using your (very helpful) Tutorial as an example - I would like to explain more clearly what I am after:

Using your City and State example - if there were also multiple Managers (Mgr) per City and you wanted a sort like:

per State NSW
per City Sydney
per Mgr <tab> Representative <tab> Sales Mgr Jones Brown $5,300
Driver $8,700
Mgr Smith Gadzic $7,400
Williams $700

My question is - Would THIS scenario use 2 or 3 keys?

my understanding is that a key is used to "keep entering data lines until you are done with that key".

In my "Would Like" example I would like it sorted by:
Employee Name
Benefit name with the price per pay period and the Benefit Amount *
Dependents for that Benefit

I cant seem to do that with the two key sort that runs "Have Now". I can only seem to do:

Employee Name
Benefit name Dependent for that Benefit
Benefit Name Dependent for that Benefit

THANK YOU very much for the learning links! I appreciate all of your help. Lisa