how can I count only distinct rows > 1, maybe in HAVING criteria?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have already created a query of distinct rows. In this same query, I need
the query to also return the rows ( the data includes an employee id) where
the employee id is found more than once.

Thanks
 
So you have a Total query where you GROUP BY [employee id].

Add the primary key to the query design grid.
In the Total row under this field, choose:
Count
In the Criteria row:
 
Back
Top