New User needs Query help - SQL Server Forums

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.

All Forums

Other Forums

MS Access

New User needs Query help

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

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources