Filter Sums By year

[vdanelia]

Hello Friends I need your help:

I have a Database [Base]: with fields: Products, Brand, Snumber, Pnumber, Price, SumAll, DateofPurchase...
The database is filled from 2009 year, now I have many records and I need to calculate the sum by years: Here is the Expression which i use, but i have to set the start year :
=DSum("SumAll","Base","Dateofpurchase >= #01/01/2009#") it is calculating from "01/01/2009" to the current date.

I created one Combo box and set the values to filter by years.....:
1/1/2011 Only this year


1/1/2010 Only this year
1/1/2009 Only this year
SUMALL All Years

Thank You in advanced

[alansidman]

Instead of > symbol, try using the between function.

Look here for syntax:

http://www.techonthenet.com/sql/between.php

Alan