G Guest Apr 28, 2005 #1 I need to creat a totals query that multiplys instead of sums. Can anyone explain how to do this?
G Guest Apr 28, 2005 #2 I found the answer to my own question. IIf(Sum(IIf([Your Field]<0,1,0)) Mod 2=1,-1,1)*Sgn(Min(Abs([YourField])))*Exp(Sum(Log(Abs(IIf([YourField]=0,1,[YourField]))))
I found the answer to my own question. IIf(Sum(IIf([Your Field]<0,1,0)) Mod 2=1,-1,1)*Sgn(Min(Abs([YourField])))*Exp(Sum(Log(Abs(IIf([YourField]=0,1,[YourField]))))
J Jeff Boyce Apr 28, 2005 #3 Gena Another way to do this would be to create a query against the field -- something like: SELECT Exp(Sum(Log([NumericField]))) AS Expr1 FROM Table1; Good luck Jeff Boyce <Access MVP>
Gena Another way to do this would be to create a query against the field -- something like: SELECT Exp(Sum(Log([NumericField]))) AS Expr1 FROM Table1; Good luck Jeff Boyce <Access MVP>
