Can a report expression be qualified by date?

[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!

 

[fredg]

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!

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.

 

[Denise]

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!

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.
.