Access Reports Can't Sum()... Other recommended Report Software??

[alwayslearning]

Any and all feedback is highly appreciated!!!

It appears that MS Access cannot Sum() complex numbers in a Report...

Are there other packages that make the process easy/seamless?
i.e.: Crystal Reports?
Others???

All comments appreciated!!!

 

[pcdaveh]

When you say complex numbers: please define.

 

[pcdaveh]

I'm assuming that when you say complex numbers you are sticking to the scientific definition, not just a hard report or task in access. If this is the case see this web site.

http://winfiles.cnet.com/apps/98/program-misc.html

the program i found was called numerit.

Hope that helps.

Daveh

 

[alwayslearning]

Thanks for the feedback!
Have downloaded your suggestion and will check it out.

I am trying to run a Report on a Query.
The objective is to calculate accumulated depreciation on a Table listing the capital assets of the company.

The formula in the Query is:
Accum Depn: ([Purchase Price]/[Depn Period])*([# Months])

[Purchase Price] and [Depn Period] are input data.
# Months: IIf(DateDiff("m",[Asset Database]![Date],[Date Query Ranges]![As At Date])+1>=[Depn Period],[Depn Period],DateDiff("m",[Asset Database]![Date],[Date Query Ranges]![As At Date])+1)

The DateDiff() formula calculates the number of months from date of Purchase and the IIf() statement ensures the number of months of depreciation is not greater than the period allowed for the item purchased.

If I Sum() each of the 3 components of the formula separately the Report calculates an incorrect answer.
The Sum() needs to be on the whole calculation for it to be correct. MS Access Reports finds this 'too complex'.

The Query runs fine, it's the Report that isn't working.
If you have any suggestions to solve this within Access that would be great!

Tks again for your time and comments!

 

[alwayslearning]

Thank you again for your feedback and comments!

It turns out my formula was not Summing() in Reports because one of the areas of the database Query was dividing by zero..(which it doesn't like to do).

When I deleted the zeros in the database and left the fields blank, everything worked like a charm!!!

Tks again!!!