Need more than one added together

  • Thread starter Thread starter Denise
  • Start date Start date
D

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!!
 
=[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?
Click to expand...

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?
 
Back
Top