Rookie needs to modify expression

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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


This expression appears to reach to the subform below the
form I'm working in (it has a table of it's own). It
returns the total of all entries.

I want to calculate prior year's depreciation so how can I
modify this expression so that it only returns the total
minus the last amount?


DepreciationDate DepreciationAmount

Thanks!
 
It's more involved than just modifying this
expression. This expression isn't an actual value, it's
the name of the text box that holds the value. You need
to look at the subform and see where this text box, [Total
Depreciation], is located. It is probably performing some
calculation or summation. This is where you will find the
field(s) that you need to make your modification.
I hope I explained that right, and that it was
understandable.
 
Back
Top