Calc fields

[nashr1928]

I am running access 2003 and have added a filed on a form that calculates total income using =Sum([name]) and this works perfect but I would like to just sum for that column for a certain year like all of 2010. What could I add to that field to do this?

[Rixxe]

Add a WHERE clause?
Where DateField = '2009*'

Or something of that nature?

Good luck.

[nashr1928]

This may be to simple. I have found that its just easiest to highlight the date on the form for the date I want and just use filter by selection. It works perfect. Thanks for your reply.

[pbaldy]

FYI, if you want to sum with a criteria while displaying all, this type of thing should work:

=Sum(IIf(Year(DateField) = 2010, AmountField, 0))

[nashr1928]

Thanks so much for your reply and suggestion.

[pkstormy]

If the year is going to change, you could also add an unbound combobox to select the year (make it a value list and values = 2009;2010;2011;2012;etc....) Then add critieria to your existing code to sum where the year matches what is selected.