Counting occurrences of same fields after a query

[jlex]

I run a Query to determine how many employees attended a meeting, showing the number of years they have worked at the company.
(Example output of query)

Employee Name Years with Company
John Doe 3
Jane Smith 1
Bill Doe 3
Rick Mills 1

How do I count the number of people with each range or particular number of years with company? For example:
2 employees have 1 year with company
2 employees have 3 years with company

 

[Pat Hartman]

Create a second query that uses the first query as its recordsource:
Select YearsWithCompany, Count(*) As CountOfYears
From query1
Group by YearsWithCompany;

 

[jlex]

Hi,

That worked great! Thanks for pointing me in the right direction.
Much appreciated.

Jen

 

[Pat Hartman]

Post your queries.

 

[jlex]

It worked Pat. Just some syntax errors on my part, but I worked them out.
Thanks again.

Jen