Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

query

1 view
Skip to first unread message

Dan

unread,
Nov 10, 2004, 9:23:02 AM11/10/04
to
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]

unread,
Nov 10, 2004, 9:57:30 AM11/10/04
to
Use a totals query:

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

--

Ken Snell
<MS ACCESS MVP>

"Dan" <anon...@discussions.microsoft.com> wrote in message
news:58e301c4c730$c9435fd0$a301...@phx.gbl...

0 new messages