query

[Dan]

i have a table which has the following fields
Lender name, loan amount,

i want to have a query that gives me totals


Bank # loans $totl amt
ABC Bank 5 $1,500,000

 

[Ken Snell [MVP]]

Use a totals query:

SELECT Bank, Count([# loans]), Sum([$totl amt])
FROM TableName
GROUP BY Bank;