Finding Last Date in a Series of Records

[BrianFawcett]

I am trying to build some reporting to forecast when orders will be completely shipped. I have orders that have variable amounts of parts and each part can have a different expected ship date.

I want to group together the orders by $ and by the last expected ship date. How can I write an expression to capture the latest date?

 

[jdraw]

What have you tried? What result?
Can you show us your tables and relationships as a jpg?