Aggregate query for education level

[catslock1]

Hi,


I have a query that shows the number of clients that have completed each grade level from Grade 1 through Grad school. I would like to use this query to group them by elementary, high school , college and grad school. Any suggestions as to how best to do this using query design?

[Welshgasman]

Have a table that defines those levels and link to it.

[catslock1]

That worked! Thank you!