Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
DAX
Starting Member
2 Posts |
 Posted - 2010-07-09 : 15:12:15
|
I have been asked to create a distribution table in Access that shows the following: Interest Rate, Record Count, Loan Balance and weighted average interest rate (weighted by balance). The presentation should be as follows:
Column1: Rate 0-2.00
2.01-4.00
4.01-6.00
6.01-8.00
8.01 +
Coumn 2: Number of records
Column 3: Loan Balance
Column 4: Weighted Average Rate
I normally do this in pivot tables in Excel, but need to start doing it in Access due to the number of records. Can someone lend me a hand? Thanks.
Carlos Laracuente |
|
|
jeremy38
Starting Member
2 Posts |
Posted - 2010-07-12 : 01:05:48
|
| Are these columns currently in the same table? |
 |
|
|
DAX
Starting Member
2 Posts |
Posted - 2010-07-12 : 08:51:11
|
quote:
Originally posted by jeremy38
Are these columns currently in the same table?
Hello Jeremy,
Yes Just one table. Thanks for responding.
Carlos Laracuente |
|
|
|
|
|
|
New User needs Query help