How do display only the field which has multiple same value?

[squirrelj]

I have a table with 2 fields (as below):

AccountOwner (AccountID,CustomerID)

Both the fields may have multiple values. To explain, a customer may have one or more accounts and an account may be owned by one or many customers (e.g. join a/c).

Here is what I want, how to do a query in Microsoft Access 2000 to just display a customer with more than one account where each account is on different branch?

There are many more tables. For above, I like mention another table called account
- one or many account is registered in one or many branches.

Hoping to hear some favourable response.

Thank you very much.

 

[Psychpt]

I don't see any mention of branch fields, but the simple form of it would be:

SELECT CustomerID, Count(*) AS NumOfAccts
FROM AccountOwner
GROUP BY CustomerID
HAVING Count(*) >1;

I also assume you would need a join to get the Customer name.

HTH

PsychPt@Hotmail.com

 

[RickSpr]

When you go to the Database Window, select the Queries tab, and click New, you'll see the New Query dialog box. In the list of wizards should be one called Find Duplicates Query Wizard. That will walk you through the steps to find duplicated values. Rick Sprague