Count and Sum Query

[Rohit Thomas]

Hello Everyone,

I have a table with the following fields: BankNumber,
RoutingNumber, and DollarAmount. I am trying to design a
single query that will group by BankNumber, then give me a
total count of Routing Numbers in the RoutingNumber field
and a total sum of the dollars in the DollarAmount field
within an certain dollar amount range. I can achive this
will two queries but is it possible to get the data with a
single query.

Thanks in advance,
Rohit Thomas

 

[Lynn Trapp]

Select BankNumber, Count(RountingNumber), Sum(DollarAmount)
From YourTable
Group By BankNumber;