Question about "averages" (1 Viewer)

Hi guys

If I have a table containing fields:
- employee
- date
- amount of jobs

As different employees work different days and have occasionally off days of course, how would I make a query with the result of a list of the employees and the average amounts of jobs per day?

Guess this is an easy one for you gurus, but I just cant get it to work.
Many thanks for the forthcoming answer(s)

Hi. Are you able to post some sample data?

You can use DCount for this, depending on how often you need to do this.

WorkDays = DCount("[Table that holds the days your employee works]", "Field", [Employee Work Day] & " Between " & [Start date] & " AND " & [End Date] )
WorkJobs = DCount("[Table that holds the Jobs your employee works]", "Field", [Job Day] & " Between " & [Start date] & " AND " & [End Date] )

AverageJobs = WorkJobs/WorkDays

If this is going to be for multiple employees you can do SUM queries for each and join them to a query on employees. You'd then have an expression that does your calculation.

same as above:

Select Employee, Avg(Jobs) As AvgJobs From YourTable;