Obtaining last shipped 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.
 
M

Marshall Barton

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.


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.
 
T

tsison7

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top