is it possible to write aggregate functions

Hi,

Probably have misread your question in my first answer.

You can, inside a query, define an arithmetic combinaison, but not your own

"external" function, using Expression (instead of Sum, Count, Avg, ..... ).

So, having the skrewness expression as the cubic polynomial summation

(Sum([FieldName]^3) + ........ ) can be evaluated such an expression, but

not: MyOwnFunction( [FieldName] ). So, basically, if it is polynomial, it

probably can be done. As example, a covariance can easily be computed

involving Sum( [Field1] * [Field2] ) + ....

Hope it may help,

Vanderghast, Access MVP.

Quote:

>Hi Robert,

>In a query? they are already built-in a Total query type (push the

summation

>button on the toolbar, or from the menu, View, check Total ) and you will

>see a new line where you can ask for Sum and Avg.

>InsideVBA, can use DSum and DAvg.

>Note that in all cases, those functions only work vertically, through the

>records, not horizontaly, through the fields.

>Hope it may help,

>Vanderghast Access MVP.

>>Such as sum or avg functions.

>>Rob Alexander