Sum Percentage

[DomP]

I am trying to sum/total/add (whatever) a perentage value. This value is being pulled from a query. Haven't been able to get this to work.

2.5
3.5
4.0
---
10.0

Also, what is the easiest way to round a percent to a whole number? 2.4 = 2 and 2.5 = 3?

Thanks,

Dom

 

[rjoubert]

What did you put for the control source of your total field?

To round your number off, set the Format property of your field to Fixed, and set the Decimal Places property to 0.

 

[DomP]

rjoubert,

Tried =Sum([PERCENT USED]) but get a syntax error.

Dom

 

[rjoubert]

Try using the DSum function.