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:
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.
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://www.yqcomputer.com/
Reply to group, rather than allenbrowne at mvps dot org.