Summing particular calculation over a certain year

[ChEStud]

Does anyone know how I would go about summing up a particular calculated field for every year (IE. A user inputs a date in 2009 for 10 different components and each component has a uniquely calculated emission. Then the total emission from 2009 for all 10 components is reported)?

[rpeare]

if your database is normalized you can summarize on a given year/month/day combination by using the datepart function

In your case you'd have datepart("yyyy", [datefield]) which would return the year the part was entered with, then if you use an aggregate query (look for the SIGMA button in your query design, looks like an upper case E) and sum on the emissions field you should get what you want.