help needed with a query calculation

[ginglis]

I have a table on which I need to perform some calculations. I basically have 1 column with a number of values as below
Column_name
12345
23342
123234234
1212
23234
12123423
324
234

The calculation I need to perform is to go through each value and calculate the percentage of the total of all the values in the column.

Help greatly appreciated.

[pbaldy]

This would probably be easier to do on a form or report. In a query, you'd have to use a DSum() or subquery to get the total on each line to do the math.