Calculate percentages in query

[delmaruser]

I have a query where I show the following results:

Cash-Out Refinance	100.00
NoCash-Out Refinance	50.00
Purchase	50.00
	200.00

What I would like to do is add an extra column to show the percentages as seen below:

Cash-Out Refinance	100.00	0.5
NoCash-Out Refinance	50.00	0.25
Purchase	50.00	0.25
	200.00	1

What is the easiest way of doing this?

Thank you,

[alansidman]

Here's a tutorial on how to do this:

http://www.datapigtechnologies.com/f...centtotal.html

[delmaruser]

Thank you for providing the link to the video this is exactly what I was looking for.

[alansidman]

Glad to have been helpful.