I am making a report but on some detail lines I am getting repeats. This looks to be caused by a field that once was 6am and was changed to 7am. For some reason the detail line comes in once as 6am and once as 7am and it is screwing up my totals.
How do I look at the latest value of the field? It used to be 6am now it is 7am, I only want to see 7am.