Hard Question

[chivo123]

Hey all,
So, I have a table named "Stats" and I have all the employees data as wells as the date that they have worked. I have built a query that calculates some other data about their facetime, total staff time, averages of their daily work, etc.... So, I would like to create a Form that would have:

Start Date----- End Date---- and when i put those two dates in there. It takes the average of those dates and it shows it to the user. I already have the daily averages, but what I want to do is to put Start Date and End Date and be able to calculate the average.

 

[John Big Booty]

Welcome to the forum.

A single table for all that data does not sound like a Normalised table structure. I would suggest that you read up on the subject (this tutorial may also help), and then redesign your table structure. This will ultimately make any other task you wish to perform, now or in the future a whole lot easier.

 

[DavidAtWork]

How are your daily averages calculated, if you already have a method to calculate this then you should be able calculate totals hours worked/total working days worked
David