---
You are getting multiple records because your tables are probably set up as one to many relationships and there is 2/more records being pulled from the table.
For example if an account is hooked to more than 1 payment plan
or the debtor has more than 1 account. These will bring up multiple records because you are not pulling anything unique from those tables.
To test try adding the primary key/unique identifier for the different tables to your query/group by statement.
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
