Obtaining last shipped date

  • Thread starter Thread starter tsison7
  • Start date Start date
T

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.
 
tsison7 said:
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.
Click to expand...


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.
 
Thanks Marshall...problem solved
--
TIA


Marshall Barton said:
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.
Click to expand...
 
Back
Top