2012-07-26, 12:26 #1
- Join Date
- Jun 2004
- Whistler, Br. Columbia, Canada
- Thanked 0 Times in 0 Posts
Average of multiples fields, ignoring zeros
I've got a number of responses to our comment card forms entered into a db and I've begun to analyse the data. Each department has multiple fields/categories they are scored on. One thing I'd like to do is get an average for the department, while not counting the zero results (indicates no response). I've calculated the averages for each categoryCode:
Eventually I'm going to want quarterly averages, overall averages, etc, and will probably want to present them in other places than just this report, so should I be doing my calculations elsewhere (currently just in the field of the report) so that they can be called for charts, other reports, etc?
Subscribe to our Windows Secrets Newsletter - It's Free!
Get our unique weekly Newsletter with tips and techniques, how to's and critical updates on Windows 7, Windows 8, Windows XP, Firefox, Internet Explorer, Google, etc. Join our 480,000 subscribers!
+ Get this BONUS — free!
Get the most of Excel! Learn about new features, basics of creating a new spreadsheet and using the infamous Ribbon in the first chapter of Excel 2013: The Missing Manual - Subscribe and download Chapter 1 for free!
2012-07-28, 00:41 #2
- Join Date
- Feb 2011
- Thanked 6 Times in 6 Posts
Look up Access help on DAvg and use the criteria "FieldName Not Is Null"