script;How can I get only the last transaction

[#1]

Dear QV-Users,

I have 2 tabels. One with the transactions in a period and the ohter table is a MASTER FILE with the StockNo. I would like to write a script that will show me only the last transaction date for each StockNo. My tabels are:

Transactions:

• StockNo
• ReceivingDate  (format is YYYYMMDD; for today it will be "20110919")
• Account
• AccountCr

MasterFileStock:

• StockNo
• UnitCost
• QuantityOnHand

Could someone tell me what the best approach will be for this case?

Regards,

Aissam

[#2 · Accepted solution]

Hi,

u can calculate the max reciving date from the first table then filter the second tabel with a left join with the first..

I hope to be clear.

C u,

Stefano.

[#3]

Try if u like this.

C u,

Stefano.