I have a list of terminated people that calculates thier tenure. I need to report on the number of people who were employed for:

0 - 6 months
6 mos - 1 yr
1 - 3 yrs
3 - 5 yrs
5 - 10 yrs
10+

I did 5 separate queries - querying out each span of time - and thought I would just add them to my report as subreports - but is there an easier way to report on this?

Thanks

Sure, calculate the tenure in the query and group by the calculated result. You can then add a group header to the report so that it will break on the tenure group

Why do you need subreport?
Just merge all 5 quiries in on query using "Union" type query.