M:M filter query

[Renoir]

Hi there,

I have a table with "payees" and "payers". A payee can work for many payers and a payer can have many payees working for them. The table records all instances where any payer hires a payee. What are the options if I want to filter on only those payees that only work for 1 payer?

Any suggestions will be appreciated.

Cheers,

Renoir.

 

[apr pillai]

payer and payees

Create a total Query. Group on Payee and take the count of Payers. Filter the Payer count=1 cases.

http://www.msaccesstips.com