Obtaining last shipped date

[tsison7]

I want to summarize shipments for a customer showing (Item No., Total Qty
shipped, Last Shipped Date)

I used a group by query and Last on the Shipped Date but the results on the
Shipped Date are sometimes wrong. How do I ensure that the Last Shipped Date
is correct? I tried sorting the query that the report is based on by shipped
date but that doesn't seem to make a difference.

 

[Marshall Barton]

I want to summarize shipments for a customer showing (Item No., Total Qty
shipped, Last Shipped Date)

I used a group by query and Last on the Shipped Date but the results on the
Shipped Date are sometimes wrong. How do I ensure that the Last Shipped Date
is correct? I tried sorting the query that the report is based on by shipped
date but that doesn't seem to make a difference.

The last record is not necesarily the one with the latest
date, especially when you consider that records in a table
are not sorted.

Use the Max function instead.

 

[tsison7]

Thanks Marshall...problem solved
--
TIA

The last record is not necesarily the one with the latest
date, especially when you consider that records in a table
are not sorted.

Use the Max function instead.