#Error in Query result

  • Thread starter Thread starter Guest
  • Start date Start date
G

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])
 
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
 
Back
Top