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.

[Robeen]

Can you explain "average of those dates"?

How can you 'average' two dates [Start Date, End Date]?

[chivo123]

So, to calculate average daily:
we had two data for calls: outbound calls and inbound calls. so I had to get the average of those 2 calls. What I need to do is now:
Create a new Form that will have:
Starting Date--- Ending Date--- Name of employee ---- Also, It calculates the average of Start Date - End Date, the stats numbers from employees that I have.
Keep in mind that I already have the daily averages.

[Robeen]

What numbers do you want to average?

You say:

I had to get the average of those 2 calls

Do you mean:
. . . the Average [Time????] of those 'two'? calls?
. . . the Average [Duration????] of all the outgoing & incoming calls?
. . . the Average [Number????] of the total outgoing & total incoming calls?

It calculates the average of Start Date - End Date, the stats numbers from employees that I have

Do you mean Start Date 'minus' End Date???
What are the 'stats numbers from the employees'?

I still don't understand what you are trying to average.

[chivo123]

Sorry for not clarfying it...
So, what I mean about averages:
So, you know about the daily averages of calls, Total staff Time.. etc.. All these are daily averages.
So, When I create a Form, When I enter the start Date and End date, It will give me the averages of the difference between those dates.
For instance: When I want the average of 8 days; I want to look at the average of 8 days of calls, total staff, Average wrap time and all that. When I want the average of 30 days, I want to look at the average of 30 days of Average calls, Total Staff time, Average Wrap up time..