Totaling a range of dates

[kcolbert01]

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

 

[IgorB]

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