Don't know what I would do without UT's help.

I have a table with part number, status, datestamp fields. There can be several records of each part number.

I need to know how many records have a ststus of 2 by part number with highest date stamp. I see the need to group by part number in date stamp order, take the latest date and see if the status is 2 and get a total count of these.