Help adding in a query

[Guest]

I have a query Multipule in that query there are fields IdNumber and Multipule.
I need to make a query that counts how many Multipule is >=2 how do I do this.

 

[Pieter Wijnen]

Per id Number:

SELECT IDNUMBER, COUNT(*) FROM MULTIPULE
WHERE MULTIPULE >=2
GROUP BY IDNUMBER

Overall:
SELECT COUNT(*) FROM MULTIPULE
WHERE MULTIPULE >=2