How to get latest date out of so many records for each item

[avik1986]

How to get the latest date and time out of the so many records for each item

[kdorian]

Have you tried using the MAXIMUM summary function? I'd suggest something like:

MAXIMUM([Pickup Date] for [Item No])

[avik1986]

Thanks it worked perfectly. :)