Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. cblesz

    Multiply multiple fields???

    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...
  2. cblesz

    Multiply multiple fields???

    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?
  3. cblesz

    Multiply multiple fields???

    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.
  4. cblesz

    Trying to use the Product function...

    I have a field with numerous values in it. Access does not have a "total" field for Product like Excel does. How can I create a function to multiply all values in the field and get one answer? In excel you just type Product(X:Y) and it multiplies the values. Thanks

Part and Inventory Search

Back
Top