I want to filter on payees that are only pauid by 1 payer (1 Viewer)

[Renoir]

I can’t seem to get this.
I want to filter on payees that are only paud by 1 payer.
Some payees have many payers and most payers have many payees.

I probably explained this a bit awkwardly last time.

In my example I would anticipate the query to return:
Payee Number = 102 (although it appears 3 times in the table it is the only Payee with only 1 Payer (Payer Number 209) the other Payees have multiple Payers)
Amount = $199 ($56+$98+$45)
Any suggestions will be appreciated.
Cheers,

Renoir

 

[Jon K]

You can do it with a series of queries.

See the queries in the database.
You can run qry3 to extract the records and qry4 to obtain the total amounts.
.

 

[Renoir]

Chears, I'll have a look at the file.
Thanks for your promp reply.
Renoir

 

[Renoir]

Cheers,

Works like a dream...