Sum of today's year minus the year of a date in the past

[Jamesiv1]

I'm trying to add a couple of fields to the Contact database in Access 2010.

In the Contacts table, I created a field called "Sobriety Date" that has dates formatted like 12/27/1995

I am trying to add a calculated field called "Years Sober" which should be the current year minus the year in the 'Sobriety Date' field (1995 in the example above).

I have been trying to tweak this:

SUM(DatePart("yyyy",[Date]) - DatePart("yyyy",[Sobriety Date]))

but it's not working. Keeps giving me "The expression that you entered is not valid for web-compatible calculated columns"



Please help?

James

[June7]

Calculated fields in tables have limitations. Not many functions recognized. Will probably have to do this calc in query or in textbox on form/report.

Use DateDiff function to calculate difference of dates. Also, Sum is an aggregate function. With exception of the row revealed at bottom of table by clicking the Totals button on ribbon, can't do aggregate calcs in table, it really makes no sense. Tables are for raw data.

[Jamesiv1]

Thank you June7. Works great!