I want to build a query like this:

Column A: Name, Column B: Value, Column C: Individual Column B Value / Total Value of Column B

However, I'm not sure how to construct Column C, currently I have:

Individual Column B Value / SUM(Column B Values)

But this just returns 1, where am I going wrong?

Thanks
Ben

Hello Ben,

Does the following do the trick for you?

SELECT Table1.Name, Table1.Value, [Value]/DSum("[Value]","Table1") AS Individual
FROM Table1;

Clive

Clive Astley

Thanks Clive this worked great!