[AccessD] complex query!!

Steve Erbach erbachs at gmail.com
Tue Jan 18 19:54:40 CST 2005


Stuart,

Yes, yes, yes...mea culpa.

Steve Erbach
Neenah, WI


On Wed, 19 Jan 2005 08:17:17 +1000, Stuart McLachlan
<stuart at lexacorp.com.pg> wrote:
> 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
> 
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 


-- 
Regards,

Steve Erbach
Scientific Marketing
Neenah, WI
www.swerbach.com
Security Page: www.swerbach.com/security



More information about the AccessD mailing list