Access equivalent of Excel's Product()

  • Thread starter Thread starter bismuth83
  • Start date Start date
B

bismuth83

Excel has a cell formula called Product() that can operate on a list
of varying size. Basically I'm looking for the equivalent for an
Access query. I haven't found anything, and it seems like such a
simple function.

Something along the lines of:
SELECT ValueTable.lineid, Sum(ValueTable.value) AS SumOfvalue
FROM ValueTable
GROUP BY ValueTable.lineid;
.... except, instead of Sum() it'd be some elusive Product() function
that I can't find.

Thanks --
 
This may not at all be what you are looking for, but one way to use products
is like this:
My product:=[tablename.filedname]*[tablename.fieldname]
 
Back
Top