<div>
Thanks. &nbsp;That was perfect.
</div>


<div>
<div class="content wysiwyg-content">
This is what I'm trying to do. &nbsp;The &quot;Date.Month&quot; (I know it's wrong) is the problem.<br />
SELECT Date,SUM(Amount) as decTotalAmount FROM Transactions GROUP BY Date.Month<br />
It should give me the total of transactions for each month.<br />
Thanks.<br />

</div>
</div>


This is what I'm trying to do.  The "Date.Month" (I know it's wrong) is the problem.
SELECT Date,SUM(Amount) as decTotalAmount FROM Transactions GROUP BY Date.Month
It should give me the total of transactions for each month.
Thanks.


How do I use the SQL &quot;SUM&quot; function and group by the month of a date field?

Visual Basic .NET (VB.NET) is an object-oriented programming language implemented on the .NET framework, but also supported on other platforms such as Mono and Silverlight. Microsoft launched VB.NET as the successor to the Visual Basic language. Though it is similar in syntax to  Visual Basic pre-2002, it is not the same technology,

How do I use the SQL &quot;SUM&quot; function and group by the month of a date field?

How do I use the SQL "SUM" function and group by the month of a date field?