Computing % of a column

From: KLP (KLP_at_discussions.microsoft.com)
Date: 03/19/05 

Date: Sat, 19 Mar 2005 11:35:02 -0800

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

Relevant Pages

  • Re: Computing % of a column
    ... Copy your query and delete the column for the LoanType field. ... This query should now have a single row and a single ... > the loan balance so I have a total of the loan balances by loan type. ...
    (microsoft.public.access.queries)
  • Re: Computing % of a column
    ... 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. ... Pleas post the query's SQL view. ...
    (microsoft.public.access.queries)
  • Re: Computing % of a column
    ... KLP wrote: ... 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. ...
    (microsoft.public.access.queries)
  • RE: many-to-many relationship
    ... > in between the 2 list boxes and a command button to run the query. ... > 1) tblLender ... > many lenders that relate to the same loan type) ... > Set a one-to-many relationship from tblLoans to tblLoanType on Loan Type ...
    (microsoft.public.access.gettingstarted)