I want the report to only show the following (highest Date1): 000123,090,621,"Loan",'600','700','2020/06/1','2020/07/01',1
I tried displaying LST.Date1 but it did not work.
In SQL I could do something like this:
SELECT * FROM ( SELECT Account,Suffix,ID,Type,Amount1,Amount2,Date1,Date2,Months, ROW_NUMBER() OVER ( PARTITION BY Account, Suffix, ID, Type ORDER BY Account DESC ) rn FROM myTABLE WHERE something ) q WHERE rn=1
Thanks GlenThis message has been edited. Last edited by: FP Mod Chuck,
June 05, 2020, 02:36 PM
BabakNYC
BY HIGHEST 1 Date1 will limit the records to the one that has the record you're looking for.