|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
August 6th, 2009, 04:24 PM
posted to microsoft.public.access.reports
|
|||
|
|||
Calculations in a report
I have the following calculation in the control source.
=Sum([CountScore1]+[CountScore3]+[CountScore10]) How do I get the total scores (i.e. 4) minus this score from 100. -- Denise B. 
|
|
#2
August 6th, 2009, 04:28 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
Calculations in a report
Denise,
Is this what you are looking for? =100 - Sum([CountScore1]+[CountScore3]+[CountScore10]) -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Denise" wrote in message ... I have the following calculation in the control source. =Sum([CountScore1]+[CountScore3]+[CountScore10]) How do I get the total scores (i.e. 4) minus this score from 100. -- Denise B.
|
|
#3
August 6th, 2009, 04:31 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
Calculations in a report
If I understand your question correctly, you want to subtract the total score
from 100, then it would be: =100 - Sum([CountScore1]+[CountScore3]+[CountScore10]) -- Dave Hargis, Microsoft Access MVP "Denise" wrote: I have the following calculation in the control source. =Sum([CountScore1]+[CountScore3]+[CountScore10]) How do I get the total scores (i.e. 4) minus this score from 100. -- Denise B.
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
