>>What does define the last record in a batch? Is it last by the date?
>>
>>See
>>
>>
Including an Aggregated Column's Related Values>
>Yes, the ActionDate column.
Ok, do I need to write this query for you or you would be able to figure this out using the blog I pointed you to?
If it's not broken, fix it until it is.
My Blog