Short Question- 100% Percent?

[kutibo]

How can I force percentages to add up to 100%? Example:
Qty. Total Qty. Percent
100 300 33.33%
100 300 33.33%
100 300 33.34%

Thanks

 

[lblastick]

In Access 2000 you can just use the round function on the result to make it the proper number of digits

ROUND(number,num_digits)

 

[kutibo]

Thanks and good idea... but I have to use '97

 

[raskew]

It's unclear how you're applying this, however, in your example:

Sum(Qty) / (Total Qty) will return 1 (i.e. 100%)