Oh, right, you are.
I think we can just make a report off the employees table. We probably will need tow reports, one for the current year and one for the last year. The reason for that is that no doubt on January 1 someone is going to ask the question about how many active employees we had last year.
I think it would be useful to create a field called [first day of the current year] with the formula of FirstDayofYear(Today()) and similarly [last day of the current year] with the formula of LastDayofYear(Today())
The the report filters would be off the employees table for
[start date] < [last day of the current year]
and
indented
ANY
[end date] is equal to blank
[end date] > [first day of the current year]
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.commark.shnier@gmail.com
------------------------------