Member Avatar for keeda
keeda 0 Light Poster

Hi,

I have a table Employee that has a coloumn EmployeeID, SupervisorID, and Active(values Yes or No).. I need to find the number of Active Employees(with Active as Yes) under each supervisor.. how can I write the query?

I am using Access 2007.

Thanks!

  • 1 Contributor
  • 0 Replies
  • 70 Views
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.