Re: Computing % of a column
From: Marshall Barton (marshbarton_at_wowway.com)
Date: 03/19/05
- Next message: Andreas: "Re: Computing % of a column"
- Previous message: Andreas: "Re: SECURITY, HELP PLEASE"
- In reply to: KLP: "Computing % of a column"
- Next in thread: KLP: "Re: Computing % of a column"
- Reply: KLP: "Re: Computing % of a column"
- Messages sorted by: [ date ] [ thread ]
Date: Sat, 19 Mar 2005 13:48:21 -0600
KLP wrote:
>I have a table which contains a loan type field, a 2 character text field,
>and the current loan balance. I ran a query on the data and it is summed by
>the loan balance so I have a total of the loan balances by loan type. How do
>I get it to compute pecentages of currbalance for each loan type? This is a
>breeze in Excel, I figured has to be away to do it in access.
>
>Type sumofcurrbalance %of total curr balance
>CM 100,000 how do I compute this?
>CR 100,000
>CL 100,000
>LE 100,000
>Total 400,000
All that in a query??? Pleas post the query's SQL view.
Would make more sense if it were in a report.
-- Marsh MVP [MS Access]
- Next message: Andreas: "Re: Computing % of a column"
- Previous message: Andreas: "Re: SECURITY, HELP PLEASE"
- In reply to: KLP: "Computing % of a column"
- Next in thread: KLP: "Re: Computing % of a column"
- Reply: KLP: "Re: Computing % of a column"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
