Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #3  
Old 12-14-2021, 08:49 AM
bananapple bananapple is offline Creating two independent NEXT IF sequences in the same document Windows 10 Creating two independent NEXT IF sequences in the same document Office 2019
Banned
Creating two independent NEXT IF sequences in the same document
 
Join Date: Dec 2021
Location: Usa
Posts: 6
bananapple is on a distinguished road
Default

Thanks for the tip! Sorry if I came across a little presumptuous, it's the first time I post here.

I downloaded the add-in, let me try again following your indications.

I've written the following field code which groups data from multiple rows:

We have the following information on Employee { MERGEFIELD "Employee" }
{ MERGEFIELD Employee_ID } - { MERGEFIELD Description } { SET ID1"{ MERGEFIELD Employee_ID } - { MERGEFIELD Description }" }
{ NEXTIF { MERGEFIELD Employee } = { MERGEFIELD Employee_Compare } }{ SET ID2 "{ MERGEFIELD Employee_ID } - { MERGEFIELD Description }" }{ IF ID1 = ID2 "" "{ MERGEFIELD Employee_ID } - { MERGEFIELD Description }" }{ SET ID1 "{ MERGEFIELD Employee_ID } - { MERGEFIELD Description }" }
{ NEXTIF { MERGEFIELD Employee } = { MERGEFIELD Employee_Compare } }{ SET ID2 "{ MERGEFIELD Employee_ID } - { MERGEFIELD Description }" }{ IF ID1 = ID2 "" "{ MERGEFIELD Employee_ID } - { MERGEFIELD Description }" }{ SET ID1 "{ MERGEFIELD Employee_ID } - { MERGEFIELD Description }" }
{ NEXTIF { MERGEFIELD Employee } = { MERGEFIELD Employee_Compare } }{ SET ID2 "{ MERGEFIELD Employee_ID } - { MERGEFIELD Description }" }{ IF ID1 = ID2 "" "{ MERGEFIELD Employee_ID } - { MERGEFIELD Description }" }{ SET ID1 "{ MERGEFIELD Employee_ID } - { MERGEFIELD Description }" }
{ NEXTIF { MERGEFIELD Employee } = { MERGEFIELD Employee_Compare } }{ SET ID2 "{ MERGEFIELD Employee_ID } - { MERGEFIELD Description }" }{ IF ID1 = ID2 "" "{ MERGEFIELD Employee_ID } - { MERGEFIELD Description }" }{ SET ID1 "{ MERGEFIELD Employee_ID } - { MERGEFIELD Description }" }
{ NEXTIF { MERGEFIELD Employee } = { MERGEFIELD Employee_Compare } }{ SET ID2 "{ MERGEFIELD Employee_ID } - { MERGEFIELD Description }" }{ IF ID1 = ID2 "" "{ MERGEFIELD Employee_ID } - { MERGEFIELD Description }" }{ SET ID1 "{ MERGEFIELD Employee_ID } - { MERGEFIELD Description }" }


As expected it provides the following output for Preview Results 1 is:

We have the following information on Employee Claire
A - Blue
B - Green
C - Yellow


So far this is perfect. The challenge I can't seem to solve is repeating this output a second time in the same word document. Copy pasting the same field code later in the word document doesn't work. I've also tried to solve this by modifying the excel database but I can't seem to get that to work correctly either. My Target output for Preview Results 1 is as follows:

We have the following information on Employee Claire
A - Blue
B - Green
C - Yellow

Here is the same information again
A - Blue
B - Green
C - Yellow


Please let me know if you have any ideas on how I can get this to work properly
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Remove number sequences mvtpinheiro Excel 3 05-09-2014 07:12 PM
animate long image sequences validusername PowerPoint 0 12-24-2013 07:10 PM
Sequential Numbering on Tickets Multiple number Sequences skitchen Word 2 10-01-2013 06:41 AM
Looping custom animation sequences or a selection of slides regilala PowerPoint 0 02-07-2010 07:35 PM
Creating two independent NEXT IF sequences in the same document Independent columns jdthelen Word 2 09-17-2009 09:34 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:31 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft