Setting criteria for a particular query 1

[bmoberly8888]

We have client numbers and matter numbers. I need a list of only the client numbers that have more than one matter number.

 

[lespaul]

something like this should work and will tell you the number of matters for each client too:

SELECT CLIENT_NUMBER, COUNT(MATTER_NUMBER) FROM TABLENAME GROUP BY CLIENT_NUMBER HAVING COUNT(MATTER_NUMBER) > 1

Leslie

 

[bmoberly8888]

Is there a way to write this in the criteria in design view?

 

[lespaul]

why don't you just paste it in the SQL view, switch to the design view and it should convert it.

I don't do Access so I don't know how to walk you through entering this there. Sorry.

Leslie