Duplicate entries

[Naqibullah]

Hello Friends Hope you all are doing well i have a bit problem in a query
i have groups and members tables in which each group is formed from no. of members, each member can take loan and will return this loan in a no. of installments so here my problem is when i run the query to retrieve no. of loans she has taken and no. of repayments she has given, this query retrieves same loan amount duplicate ...i want you to help me how to group by this query so that when i run this query it should only retrieves that no. of loans(no duplicate) she has taken and no. of repayments (no duplicate) she has given... for ur more information i attached the db here in this post
thanks in advance

 

[Naqibullah]

Plz refer to summary sheet query in the attached db

 

[JHB]

Please, show which result you want, then it is easier to help you?

 

[Naqibullah]

ok let me shed light on that....we have seen bank account statements which shows list of our withdrawals and deposits same thing i want to show list of loans and list of repayments for a specific member...for better example i have attached an word file of what i want

 

[JHB]

It didn't help to much, because the member "Jorge" wasn't in the database, so it didn't know the basic data for the member.
I've instead taken a print shot from the report and the data which where in the database, is this result what you are looking for?
If yes then you can set the "Hide Duplicates" property for each text control in the report?