I am creating an application in MS ACCESS97. I have a table with employee start date and termination date.
The user will input two dates and I need to have the program calculate the average number of employees that existed for that period. So it has to parse all the dates and count how many employees existed on each date and then divide by the number of days.
Any Ideas??