[AccessD] complex query!!

Stuart McLachlan stuart at lexacorp.com.pg
Tue Jan 18 16:17:17 CST 2005


On 18 Jan 2005 at 8:20, Steve Erbach wrote:

 
> I was going to modify the SQL statement I came up with for Pedro a few
> messages ago, but I discovered that Access has very poor math
> function. It has the exp function (e^x) but no function for raising a
> quantity to an arbitrary power. 

?  (A1-B1) ^ 2  

> It has the sqr (square root) function
> but no function for squaring a number! 

?  3 ^ 2
-- 
Stuart





More information about the AccessD mailing list