How do you sum based on calendar year that has multiple years?

  • Thread starter Thread starter Rick
  • Start date Start date
R

Rick

I have a DB that has dates that I want to sum up by year. I was trying to
use the IIf and DSum command together. Is there another way or how do you
imbed the DSum function in the IIf function?
 
Use a totals query.

In query design, depress the Total button on the toolbar.
Access adds a Total row to the query design grid.

In the Field row, enter:
TheYear: Year([d])
substituting your field name for [d].
In the Total row under this field, accept Group By.

You can now sum the other field to get a total for each calendar year.
 
Back
Top