Fed Alexander
asked on
Sum/Avg/Max/Min
Hello Team,
I am trying to calculate Min, Avg, Max, Standard deviation and count based on specific criteria. I want to calculate based on number of shifts and based on titles. this will need to be by month, July, August, Sept and by year.
one staff may have worked 4 shifts per month, then went on vacation. if he cared for 100 customer during the 4 days, max would be 100, average would be 25...etc. I want also to count the number of shifts he worked, and the number of customer he cared for. the result needed is by title also. I used the query below and I got a strange results.
Database44.accdb
I am trying to calculate Min, Avg, Max, Standard deviation and count based on specific criteria. I want to calculate based on number of shifts and based on titles. this will need to be by month, July, August, Sept and by year.
one staff may have worked 4 shifts per month, then went on vacation. if he cared for 100 customer during the 4 days, max would be 100, average would be 25...etc. I want also to count the number of shifts he worked, and the number of customer he cared for. the result needed is by title also. I used the query below and I got a strange results.
Database44.accdb
No query is attached.
Easy! Got it working without any problem! See query attached.
I guess this is the question of the "invisible query"...now you see it...now you don't... :)
John: Don't think too hard on this one. I used Fed's attached query to come up with my answer..... ;-)
Still not seeing it... : )
ASKER
there is no attachment....
And do you plan to post one?
Otherwise the only proposal we can do is:
SELECT MIN(SomeColumn), MAX(SomeColumn), AVG(SomeColumn)
FROM SomeTable
WHERE SpecificCriteria
You should also provide some data samples and tell what's strange with your results.
Otherwise the only proposal we can do is:
SELECT MIN(SomeColumn), MAX(SomeColumn), AVG(SomeColumn)
FROM SomeTable
WHERE SpecificCriteria
You should also provide some data samples and tell what's strange with your results.
ASKER
sorry folks, for some reason the database was not attached in the question when i sent it. my apology!
kindly see attached database
kindly see attached database
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
This works for me. thank you!
ASKER
Brilliant!
Glad it worked as you wanted...:)...