Multiply multiple fields???

[cblesz]

I am trying to use the Product or geomean function in excel in Access. Since these functions are not available, I am trying to create one and having a problem. How can I create a function like the Sum function in Access that is the Product function. Thanks.

 

[Aivars]

VBA support function Sum()- see Help. Also you can make query what sum needed field's values.

Aivars

 

[cblesz]

I know how to use SUM. However, I want the PRODUCT. For instance, I have a field in a table that has 30 numbers. I want the total of the PRODUCT of those numbers...(#1 * #2 *#3...etc.). How can I do that?

 

[JoeMiller]

This web site will show you how to use Excel functions in Access so you don't have to create your own:

http://www.fabalou.com/Access/Queries/excel_functions.htm

HTH Joe Miller
joe.miller@flotech.net

 

[cblesz]

I have seen that, thanks though. This is the problem. I have a table with dates and performance return numbers. I am trying to create a query that will multiply each of the performance numbers together (product) and give me a result. Kind of like the Stdev or sum function. I want the query to do what the Sum function does, but rather than add the numbers, I want it to multiply the numbers. The field name is LAGG, and each date has a number (eg: 1.02, 1.31...). How can I create a function that will multiply all the numbers in the same field and give me a total? Let me know if this isn't clear and thanks for your help.