Finding Latest Date of Purchase Order Transactions

[Guest]

Hi!
I am really new to ACCESS and am needing to find the latest transaction of
each product (PRODNO) for each Purchase Order (PO) in my Table named MMTRAN.
This table has fields of PO number (PONO), Product number that is purchased
(PRODNO) and the Transaction Time (TRANTIME). There are others but those
fields do not play a part in this i do not think.

Now each PO can be recivied in multiple times for each product purchased,
for example we order a qty of 100 of part# ACME12 on a PO and the company can
send us a qty of 25 then later another 25 that after that we receive in the
last 50 to complete the total 100 that was purchased.

Each of those times it is received is a seperate line in the MMTRAN table
with the transaction time of each is created. So I need to find only the
last time a product is received for each PO. We need to find out how long
it takes vendors to complete a PO for each part we order. The Products can
show up on multiple POs and I need to see the output of each PO that a part
appears on.

If anyone can help I would be greatly apprecitive and as always THANKS IN
ADANCE!!!

Chip

 

[Guest]

Create a query based on the MMTRAN table. Choose the PO, TranTime, and PRODNO
fields. Select Totals under the view menu. Under the TRANTIME field, select
Max. Leave the other two set to GroupBy.

This should get you what you need.

Barry