Current payment due

  • Thread starter Thread starter Oscar
  • Start date Start date
O

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
 
Do a group by (the little E at the top) and then change the group by for
Payment to max.
 
Back
Top