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
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!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Trying to use the Product function...
- Thread starter cblesz
- Start date
LonnieJohnson
Programmer
The approach would be to create a new field. It's value would be derived from the syntax...
[Field1] * [Field2]
How you insert this expression would depend on if you are running a query, a report or opening a form.
Let us know.... The Tek-Tip Collective ljprodev@yahoo.com
ProDev
MS Access Applications
[Field1] * [Field2]
How you insert this expression would depend on if you are running a query, a report or opening a form.
Let us know.... The Tek-Tip Collective ljprodev@yahoo.com
ProDev
MS Access Applications
- Status
Similar threads
- Question
- Locked
- Question
- Locked
- Question
