Hello everyone,

I have a database where I collect shipment data from various tables.
However, I have a problem. Whenever I want to see shipping data for
orders that were set to ship on or before a certain date (in this case
January 30th) the database will return 2 rows for an order as you can
see below.

Order ID:  Line: Due Date:     Qty:     Ship Qty:     Part #:  Shipped:
141285        1   1/30/2006      31         10        S15F-55
1/17/2006
141285        1   1/30/2006      31          21       S15F-55
1/27/2006

This is actually one order, that was shipped over the course of
multiple dates. However, I want Access to combine this information into
one record becaue I count the total number of shipped orders in another
query for use in a shippin report. This causes my report to have
incorrect data because it shows 2 orders instead of 1 that just shipped
over the course of multiple dates.

How can I combine these records if the following is true:
If Order ID, Line, Due Date, Qty, and Part # are all the same -
I want Access to combine these records into one line displaying the
greatest shipdate (in this case 1/27/2006).

So in the end, I want my result to look like this:

Order ID:  Line: Due Date:     Qty:     Ship Qty:     Part #:  Shipped:
141285        1   1/30/2006      31          31       S15F-55
1/27/2006