I am trying to modify a report that looks at several dates when the data was modified. For instance:
Order No:12345 Date Processed: 1/1/2011 9am Hours assigned to Order:3
Order No:12345 Date Processed:1/1/2011 3pm Hours assigned to Order:3
So in this case I want the latest Processed date (3pm) and only 3 hours for the (3pm) order. Any suggestions?