Need more than one added together

[Denise]

=[Depreciation Subform].[Form]![DepreciationAmount]

Instead of saying DepreciationAmount, how can I say add
all depreciation amounts with labels that have a date
prior to the current year?

Can that be done?

Thanks!!

 

[John Vinson]

=[Depreciation Subform].[Form]![DepreciationAmount]

Instead of saying DepreciationAmount, how can I say add
all depreciation amounts with labels that have a date
prior to the current year?

Labels? If you have fields named DepreciationAmount1999 and
DepreciationAmount2000 and DepreciationAmount2001 then your table IS
NOT CORRECTLY DESIGNED.

What's the structure of the table upon which the subform is based?