RecordID RecordDate PersonName RecordNote LineOrder 1 10/25/2016 John Doe test1 1 1 10/25/2016 John Doe test2 2 1 10/25/2016 John Doe test3 3 2 10/25/2016 Jane Doe testing23 1 2 10/25/2016 Jane Does testing27 2
This way the first 3 fields are repeating for each record with the same record ID. I was wondering if I can somehow only display RecordID, RecordDate, and Person Name in a row if it is not repeating.
For example:
RecordID RecordDate PersonName RecordNote LineOrder 1 10/25/2016 John Doe test1 1 test2 2 test3 3 2 10/25/2016 Jane Doe testing23 1 testing27 2