Need to multiply in aggregate query

  • Thread starter Thread starter Guest
  • Start date Start date
Gena said:
I need to multiply instead of sum in a totals query. Is this possible?
Click to expand...

Based on that sketchy question, try this:

=Exp(Sum(Log(field)))
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

aggregate query multiply instead of sum 2
ms access product function 2
Incorrect sum in MS Access query 1
Counting in Queries Ends Up Multiplying 2
Opinion about aggregates 8
Multiplying field in query 7
How do I prevent values from been multiplied by two or three? 4
Aggregate Query in Access 2007 1

Back
Top