here is a slight variation to what Michael Valentine Jones provided:

declare @year smallint,

@month tinyint

set @year = 2007

set @month = 2

select

sum(Amount)

from

dbo.myEntries

where

myEntries.myDate >= dateadd(yy,(@year - 1900), 0)

and myEntries.myDate < dateadd(mm, @month, dateadd(yy,(@year - 1900), 0))

😎