Need to pull the last inventory transaction for each part id

[loriswanson2014]

I am trying to query our inventory transaction table. I want to pull the last inventory receipt for each part id we have. All of my results gave me multiple instances of the part id (received on multiple dates). I used MAX in the transaction date and also tried in the part ID field. Not working...

thanks

[June7]

See if this helps http://allenbrowne.com/subquery-01.html#TopN

[NTC]

well you state that you used MAX but it did not work; and so that statement has to be explored. What is the db's definition of the "last" inventory receipt? ...as this must be the Max of some field/parameter one would think. If not date then what? perhaps the autonumber key? .....

[loriswanson2014]

The table has inventory transactions. I want the most recent transaction for each part_id in the table. If there were a receipt each week, then I would want to just see the most current one. I need additional information as well...is it best to do 1 query to get the last transaction and then use that in a query to add details?

[June7]

Did the Allen Browne link help?

It is possible to do this with domain aggregate functions but would be better with nested subquery.