Trouble Running Sum Function On Access Report

[bigmerf]

In Access 2003, I have a report that I've created based on a query of data. On this query, I have a formula calculating present value. The formula is this:

PV([cust interest rate]/12,[monthsremain],[lease payment],[current residual],1)

On this report, I have a customer grouping that I want to SUM the present value of all leases by customer. Everytime I apply the SUM function to my "PV" field, I get an ACCESS error stating that the formula is "too complex to be evaluated". I'm doing all of the work to calculate the PV on the query, the only thing I want the report to do is sum the PV's by customer.

Is there another function that is more "powerful", or is there something that I'm missing that it won't add the totals together in a footer? I tried the calculation on the report side as well, but to no avail.

Please help.....

 

[bigmerf]

Does anyone have a solution for this problem??

 

[bigmerf]

For anyone that may be curious, I fixed this problem by running a "Make-Table" query to write the data to a separate table. There I pull the information in to the report and am able to do the "summation" there.

It appears that because the PV formula is calculating so many figures, the SUM function makes the formula too complex for access to process. Moving the data to another table where no calculations are taking place allows me to calculate SUMS and COUNTS or any other calculation for that matter with no errors.

Thanks!