Sums in access reports

[Ricky21]

Hi all,

Access is new to me.

I have a table with number values, and in my report I have a total count which adds all the number values in the table together =sum([CountOfID]).
I now want to divide this total against each individual value and multiply it by 100. Example 7 is a value in the field which is getting total. So it is 7/total*100. But I am having problems doing this with the brackets.

If anyone gets this can you help

Thanks

Ricky

 

[Pat Hartman]

=[someField] / [sum from report footer] * 100