#Error in Query result

[Guest]

I have a calculation in a query that gives #Error in some of the results.

Calculation is as follows:
(([Price]*(1+[Rate]/365))^[Days])

The error does not occur when I drop the end part of the calc----- (^[Days])

 

[Michel Walsh]

Hi,


Is it possible that Price is negative?


(-1)^2 = 1,
(-1)^3 = -1,


so what would be the sign of

(-1) ^2.5 ? +1 or -1 or something else?


That is why a negative number cannot be raised to a not integer power (you
can, but only if you consider the Complex set of numbers, but not if you
limit yourself to the Real set of numbers).



Hoping it may help,
Vanderghast, Access MVP