Use total in table (1 Viewer)

I have a table
1 12 20 0.16
2 10 30 0.24
3 5 25 0.2
4 7 35 0.28
5 13 15 0.12
Total 125


first column item
second column price
third column expenses
forth column is the percent of the expenses to be calculated

I need to get the results 0.16,0.24,........

As ex in the first row 20/125=0.16
30/125=0.24

i need to use the total of column to be divided in another column to get the percent of this item from the expense

Cross posted at: http://www.accessforums.net/showthread.php?t=71907&p=396747&posted=1#post396747
You are new to both forums and may not be aware that if you cross-post you should state you have done so & provide the link yourself

Select Item, Price, Expense, (Expense/(Select Sum(Expense) From Table)) As Percent From Table