percentage of grand total

[ds]

Hi,

For each record, I have a field called "Cost". And I want
to calculate the percentage of this cost in the total cost.

Example:

Item # Cost
1 20
2 10
3 5
4 15

Since the total cost is 20+10+5+15=50

I want the following result:

Item # Percentage out of total cost
1 20/50=40%
2 10/50=20%
3 5/50=10
4 15/50=30%

How can I do this using a query?

Thanks for help.

ds

 

[ds]

Thank you so much Van, it worked!

But, I don't really know how to write SQL...is there a way
to do this in design view?

Is Main the subquery that you created?

Thanks a lot,

ds