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.