MS ACCESS -counting records - TechRepublic
General discussion
March 28, 2001 at 03:31 AM
nicholasp

MS ACCESS -counting records

by nicholasp . Updated 25 years, 1 month ago

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??

This discussion is locked

All Comments