Calculate at report level

[jburns]

I'm trying to create a report showing depreciation over
forty years. I can create a query that shows the
depreciated amount for each year but this becomes a bit
ungainly as I have something along the lines of YearFour:
Cost - YearOne-YearTwo-YearThree * rate and so on for
each year. This also means that the processing is done on
the server rather than the client.

I belive there may be a simpler way to perform this
calculation at the report level and using code that loops
to provide the required values for all years. Can anyone
help me out? Thanks in advance

 

[Jeff Boyce]

That will depend on what underlying data you have to start with. What's
your data structure?

Have you considered writing a procedure that returns the calculated value,
then calling the function in a query?

More info, please...

Jeff Boyce
<Access MVP>