Re: Computing % of a column
From: KLP (KLP_at_discussions.microsoft.com)
Date: 03/19/05
- Next message: John Vinson: "Re: searching for text in a field - better way?"
- Previous message: Andreas: "Re: Computing % of a column"
- In reply to: Marshall Barton: "Re: Computing % of a column"
- Next in thread: Marshall Barton: "Re: Computing % of a column"
- Reply: Marshall Barton: "Re: Computing % of a column"
- Messages sorted by: [ date ] [ thread ]
Date: Sat, 19 Mar 2005 11:57:02 -0800
Here is the SQL view: SELECT Sum(data.curbalance) AS SumOfcurbalance,
data.lntype
FROM data
GROUP BY data.lntype;
I only have the first two columns and no total. The right hand column was
to illustrate what I wanted to don. I know I can get the total via a report,
but how do I get the percentage of each type?
Thank you,
Kelvin
"Marshall Barton" wrote:
> 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: John Vinson: "Re: searching for text in a field - better way?"
- Previous message: Andreas: "Re: Computing % of a column"
- In reply to: Marshall Barton: "Re: Computing % of a column"
- Next in thread: Marshall Barton: "Re: Computing % of a column"
- Reply: Marshall Barton: "Re: Computing % of a column"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
