[AccessD] Function in query as criteria

Mark Whittinghill mwhittinghill at symphonyinfo.com
Fri Feb 14 10:48:00 CST 2003


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




More information about the AccessD mailing list