Last shipment date

[Alan]

This is an add-on to a large MRP program we use. Tables of interest are
the Parts and the DeliveryDetails tables. Parts contain the data for
each unique part manufactured. DeliveryDetails contains the shipment
details for each time any part has ever been shipped.

I need a query to provide the last shipment date for every part in the
Parts table. I will be feeding these results into a subsequent query so
the table must contain ONLY a single entry for each PartNo.

Appreciate the help.

Alan

 

[Nikos Yannacopoulos]

Alan,

Make a new query on the Delivery Details table. Get the PartNo and
ShipmentDate fields down to the grid, then do menu item View > Totals.
Notice the new line heahed Total: that appears in the grid; the default
setting is Group By for all fields. Leave as is for the PartNo field, and
change to Max for the date field, and you're done.

HTH,
Nikos

 

[Alan]

Seems to have worked. Thanks - was having a severe mental block.

Alan