multiply more than entry in a table

  • Thread starter Thread starter Chris Wainwright
  • Start date Start date
C

Chris Wainwright

Hi there,

sorry to hassle you all but I have a table where each client may have more
than one mulitplier attached to their file

eg.

Client 1 . . . 1
Client 1 . . . 2
Client 2 . . . 2
Client 2 . . . 2
Client 2 . . . 2

I need to calculate the product of all the entries ie client 1 would be
1*2=2 but client 2 would be 2*2*2=8

Any suggestions?
 
Chris

"How" really depends on "what". It all starts with the data. If you'll
provide a bit more specific description about what data (i.e.tables, fields)
you're using, the folks here in the newsgroup may be able to offer more
specific suggestions.

By the way, do a search on this topic ... I recall a similar question (and
solution by Duane H.) a bit back. I think Duane offered using a log
function...

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/
 
This is the reply from less than a week ago in the Access Reports NG

You can try an expression in a report or group header or footer like:
=Exp(Sum(Log([Num])))
 

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

VPN server without domain controller 0
Excel Consecutive counts with conditions in excel 0
Link tables question 1
How to Exclude result from one query from another 4
Numbering in a table 3
combine notes in separate rows... 3
Filtering a table by using criteria in another table 1
Select Last payment date and amount of a group 9

Back
Top