Hello M, I don't know if you want the average or the median. The average is the max number plus the min number divided by the amount of numbers (as far as I remember). The median is the total of all the numbers divided by the amount of numbers.
Either way I guess you need to find the number of numbers (confusing aint it). Off the top of my head, I can't test it cos this thing doesn't have Access. Me.RecordsetClone.RecordCount should get it for you. Hope that helps. Robin --- In [email protected], "martha11ces" <[EMAIL PROTECTED]> wrote: > 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 --------------------~--> Fair play? Video games influencing politics. Click and talk back! http://us.click.yahoo.com/T8sf5C/tzNLAA/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/
