Skip to Content
Former Member
May 18, 2009 at 09:10 PM

Multiple Transactions Date and Status - Obtaining the last one


I am trying to obtain the last transaction from an customer decision based on the last decision date and therefore obtain the last decision status. However when I add the fields of the decision status it brings duplicate transactions from the same customer, bings all the transaction description along with the corresponding date/time.


Decision Status Decision Date/Time

Record 12345 - Denied May 1, 2009

Condition May 2, 2009

Approved May 3, 2009

In this case I only want the customer 1235 - Approved - May 3, 2009

Any recommendations?