Very New User Needs Help With Access Expression

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

Denise

=Sum(IIf(Year([DepreciationDate])=2002,
[DepreciationAmount]))

Can someone help me with this expression?

Forms are called "Assets"
On Each form are two buttons - "Maintenance"
& "Depreciation"
Clicking "Depreciation" brings you to a sub-form
where one of the fields is "Total Depreciation" -
this is the total from a table below
entitled "Depreciation Details" which allows you to
enter each amount by date. The table column titles
are "Date" & "Amount"

It appears to me that Access won't reach into this table
because it always asks me for a value for
DepreciationDate. Do I need to create a new field in the
sub-form first?

I'm trying to enter the correct expression in 3 columns of
my summary report.

I want, in 1 column - the prior years accumulated
depreciation - it has to reach into this table and add all
depreciation entries, for that asset, prior to the current
year.

Column 2 should be the current depreciation which would
have to pull just the entry for this year

Column 3 is working fine - the expression I'm using is:
=[DepreciationAmount]. To be honest, I'm not even sure
WHY it's working - I'm that much of a rookie. It's
displaying the total accumulated depreciation for each
asset.

Thanks so much!
 
Denise,

You mentioned that the field in the table is named Date, and yet your
calculation expression refers to DepreciationDate. Have I missed the
point, or... which one is it?

By the way, the word 'date' has a special meaning in Access (it is caled
a reserved word), and as such it is not a good idea to use it as the
name of a field or control or database object.
 
Back
Top