Getting the sum from database

Question

The database has a field that stores a date value and another that stores an integer. I need the sql statement to retrieve the sum of the integer column whose month in the date is a specified month. I use access as the database.

Answer 1

select sum(the_integer_field) from your_table where month(the_date_field) = your_value

Answer 2

you can’t use functions after the where clause right??