Henry Simpson
hsimpson88 at hotmail.com
Fri Feb 14 11:05:47 CST 2003
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