I have a table that tracks job positions. I keep the date, the department and the position. What I would like is if infomation is added but the person has the same position and department I would like to just display a brief overview.
Example
Date PayIncrease Salary % Bonus Date_ Program Position
5/ 1/2003 $0.00 $2,000.00 0.00% $0.00 Limited Internship Partnership Development
5/ 5/2003 $600.00 $2,600.00 23.00% $200.00 5/6/2003 Management and General Expense Administrative Assist.
5/ 6/2003 $0.00 $2,600.00 0.00% $0.00 Management and General Expense Administrative Assist.
5/15/2003 $0.00 $2,600.00 0.00% $0.00 Management and General Expense Administrative Assist.
For that data set I'd like it to read
Date PayIncrease Salary % Bonus Date_ Program Position
5/ 1/2003 $0.00 $2,000.00 0.00% $0.00 Limited Internship Partnership Development
5/ 5/2003 $600.00 $2,600.00 23.00% $200.00 5/6/2003 Management and General Expense Administrative Assist.