How create query to capture last three records for a key number
Posted on 2014-02-11
I need to design a query that will sum the values in a field named "ScrapQty for the last three orders in tblOpenOrders.
The tables are tblOpenOrders and tblFinished. tblFinished is where the field named "ScrapQty" is. They are linked via a field named "OpenOrderID"
I know how to sum all records but do not know how to sum just the 3 most recent records.