[AccessD] Function in query as criteria

Hey,  that was an obvious way to find out :-)

The answer is it only runs once.  Thanks for the advice.


Mark Whittinghill
Symphony Information Services
Minneapolis, Minnesota
Email: mark at symphonyinfo.com
Phone: 612-333-1311
----- Original Message -----
From: "Henry Simpson" <hsimpson88 at hotmail.com>
To: <accessd at databaseadvisors.com>
Sent: Friday, February 14, 2003 11:04 AM
Subject: Re: [AccessD] Function in query as criteria


> Why don't you place a break point in the function and tell us?
>
> Hen
>
>
>
>
> >From: "Mark Whittinghill" <mwhittinghill at symphonyinfo.com>
> >Reply-To: accessd at databaseadvisors.com
> >To: "AccessD" <accessd at databaseadvisors.com>
> >Subject: [AccessD] Function in query as criteria
> >Date: Fri, 14 Feb 2003 10:50:31 -0600
> >
> >Hi all,
> >
> >   I am writing an Access query which uses a VB function such as:
> >
> >SELECT Field1, Field2, MyFunction(Field3, Field4) AS CalculatedField
> >FROM MyTable
> >WHERE MyFunction(Field3, Field4) > 0
> >
> >Will MyFunction have to run twice for this query, once for
CalculatedField,
> >and once for the WHERE?
> >
> >TIA
> >
> >
> >Mark Whittinghill
> >Symphony Information Services
> >Minneapolis, Minnesota
> >Email: mark at symphonyinfo.com
> >Phone: 612-333-1311
> >
> >_______________________________________________
> >AccessD mailing list
> >AccessD at databaseadvisors.com
> >http://databaseadvisors.com/mailman/listinfo/accessd
> >Website: http://www.databaseadvisors.com
>
>
> _________________________________________________________________
> The new MSN 8: advanced junk mail protection and 2 months FREE*
> http://join.msn.com/?page=features/junkmail
>
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>