Skip to Content
0
Former Member
Sep 02, 2009 at 03:53 PM

How to duplicate a row?

15 Views

Hello to all and good morning, I'm working on report that I need to duplicate a row if a field is true:

Invoice#.........Salesname1.......Salesname2

.......1.................Smith, R........... Barnes,

...... 2.................Saywer,t........ Paynee, T

...... 3................. Wayne,R.........Smith, R

Smith,R should have 2 rows because he was involve in 2 transactions , I'll group by salesName this what I'm looking for:

Smith,R

Invoice#.........Salesname1.......Salesname2

.......1.................Smith, R........... Barnes,

...... 3................. Wayne,R.........Smith, R

Thank you for any help.