Current payment due

[Oscar]

Hi,

I'm trying to run a query where I can pull the current payment due on a
account. When I run the query I get the same account repeated since it gives
me the payment due history. What can I enter in the criteria so that it can
only give me the current payment due?

I have three fields: "Due Date", "Payment" and "Escrow Payment"

Thanks

 

[Golfinray]

Do a group by (the little E at the top) and then change the group by for
Payment to max.