|
Subject:
|
Query Quandry
|
|
Posted By:
|
Ben
|
Post Date:
|
2/9/2004 12:03:16 PM
|
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
|
|
Reply By:
|
Clive Astley
|
Reply Date:
|
2/9/2004 1:45:25 PM
|
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
|
|
Reply By:
|
Ben
|
Reply Date:
|
2/10/2004 5:30:26 AM
|
Thanks Clive this worked great!
|
