I figure this is relatively simple - I just don't know the exact phrase to use to achieve what I need.
I have a field that I would like to contain the average of all the numbers added together. This would be straight forward if I knew how many numbers would be added up (i.e. The average of a series of numbers: 6,4,5,6,4 would be 5 - sum/total # of items). However, when I filter my records - I might have any number of 'total # of items.' How do I add the equation in Access? It will look something like: =([Item1Sum])/"total # of filtered records" What is the proper way to write "total # of filtered records?" Thanks! M. Matthews ------------------------ Yahoo! Groups Sponsor --------------------~--> Most low income households are not online. Help bridge the digital divide today! http://us.click.yahoo.com/cd_AJB/QnQLAA/TtwFAA/q7folB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
