Hi that helps tremendously thank you.

How would i modify your logic so that it looks at 2 columns rather than the 1 (account). Here's what i'm trying to say:

Meter ...

Solution to my problem is this:

SELECT A.ACCT,A.TRANDATE,A.TRANAMOUNT,A.RWID

FROM MYTABLE A

WHERE RWID = (SELECT MAX(B.RWID) FROM MYTABLE B WHERE B.ACCT = A.ACCT)

Figured out. Thread closed