Employment per week

Hi,

I need to create a report that counts employees for each week. The output should look like this:

Week_Start Week_End Emp_Count

05/27/2001    06/08/2001    42
06/03/2001    06/09/2001    44
06/10/2001    06/16/2001    44

etc.

The Emp table has emp_num, Emp_name, Start_date and Term_Date along with the rest.
Only full employment weeks should be counted for each employee.

Thanks in advance,
Vladimir Received on Tue Jun 12 2001 - 17:45:01 CDT