Trying to think of an easy way to do this. I have many rows per SuppID. When a form comes up that shows actions for the supplier, it sorts by DateVersion then by SeqNo. There is an autonumber PK field, but it cannot be relied on for being the exact order, nor are the SeqNo's sequential in this table.
I am designing a report showing supplier information, and for some of the data I need to find the LAST action row for each supplier. I would be fine with defining a temp table before the report comes up, doing the calc in the table, then looking up data from the report. For example, the actions form would come up like this. I would want to grab the PK of the LAST row I'm showing DateVersion SeqNo 03/01/15 1 03/15/15 4 04/01/15 2 04/01/15 3 Any clues? Thanks! Karen
