Can a report expression be qualified by date?

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

Denise

I'm very new to Access.

Can this expression =[DepreciationAmount]be qualified by
date?

This expression gives me the accumulated depreciation for
all years since we've had the asset.

I need one of the columns to print accumulation through
the prior year first. Can I qualify this?

Thanks!
 
I'm very new to Access.

Can this expression =[DepreciationAmount]be qualified by
date?

This expression gives me the accumulated depreciation for
all years since we've had the asset.

I need one of the columns to print accumulation through
the prior year first. Can I qualify this?

Thanks!
Click to expand...

Without fully knowing what you need, here's one way to limit data to a
particular year.
In an unbound conrol's control source:
=Sum(IIf(Year([DateField])=2003,[DepreciationAmt],0))

You could also use
=Sum(IIf(Year([DateField]) = (Year(Date())-1) ,etc)
to always get the previous year.
 
Thanks Fred for your time. I'm working with the formulas
you suggested. My "date field" is called DepreciationDate
but each time I enter it, prior to the report running it
asks me to Enter Parameter Value for the field
DepreciationDate.
-----Original Message-----
I'm very new to Access.

Can this expression =[DepreciationAmount]be qualified by
date?

This expression gives me the accumulated depreciation for
all years since we've had the asset.

I need one of the columns to print accumulation through
the prior year first. Can I qualify this?

Thanks!
Click to expand...

Without fully knowing what you need, here's one way to limit data to a
particular year.
In an unbound conrol's control source:
=Sum(IIf(Year([DateField])=2003,[DepreciationAmt],0))

You could also use
=Sum(IIf(Year([DateField]) = (Year(Date())-1) ,etc)
to always get the previous year.

--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
.
Click to expand...
 
Back
Top