Hi,

I think we need to see a sample of the data layout.
Do you want a count of these people or do you want to do a query on an
individual?

Mike

"Reenee" wrote:

I have hire dates and term dates that I ran in a report and it is over 10K
rows and I need to know if someone was hired in 2007 or before but terminated
in 2008. I also need to run the function for anyone who was hired in 2007 or
before and are still active.