Is there a 'work around' to Sum() a complex #???

[Mike A]

All help is very much appreciated!!!!!
I have a Report completed except for 2 columns that I need to Sum()!
The numbers in the column are coming from a Query with the following complex formula:

Accum Depn: IIf([Depn/Mo]*IIf([# Months]>[Depn Period],[Depn Period],[# Months])>=[Purchase Price],[Purchase Price],([Depn/Mo]*[# Months]))

Two of the items in the formula come from other columns with the following formulae:

# Months: DateDiff("m",[Asset Database]![Date],[Date Query Ranges]![Date(s)])+1

Depn/Mo: SLN([Asset Database]![Purchase Price],0,[Asset Database]![Depn Period])

Is there some way to use code, or change the structure so the Report will Sum()???

This is the last piece I need to complete the Report!!! Can MS Access do it????
Thankyou for any and all feedback!!!

 

[Mike A]

It appears that my problem with the complex formula was one of the data areas with zeros.
Access would not Sum() a formula in which there was a division by zero.
When I deleted the zeros, everything worked fine.