Hi,

I believe I have the solution. Still verifying, but it appears to work.

Thanks.

SELECT DISTINCT

ID, NAME, FOP

, ACCT, CTNUM, ENDDATE

, DEBIT, CREDIT, TRANSACTION_DATE

, ...

Grant..thanks for replying. I took a look at the web page, but it's hard to follow along without any real data in the examples and the results thereof.