[AccessD] German vs. germane - WAS Function in query as criteria

Actually I am partly German.  My ancestor stowed away on a ship from Germany
in the 1760's or so, and somehow his German name became Whittinghill.
During the Revolution he managed to go AWOL and I believe ended up in
Kentucky, where my dad's family comes from.  This also isn't germane, but it
is Friday, or Freitag.

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 12:39 PM
Subject: Re: [AccessD] Function in query as criteria


> Then what you have to do is scroll the query window to watch it run as
> values come into the display scope.  Then check how it runs with compound
> criteria such as:
>
> fldValue > 500 And fldValue < 800 And MyFunction(Field3, Field4)
>
> Then see if it runs with OR criteria where there is a simple range
criteria
> that can qualify it without running the function.  Does it even run once
if
> the other criteria preclude inclusion in the result set?
>
> There is much to learn about how queries run when you 'step through' them.
> Although there is little reference information on how this all works, it
is
> always illuminating to watch through the windows we have on the processes.
> To mix a few threads, once you know how to fish, you may live in a
coloured
> house, and though starvation for knowledge may be thwarted, I wonder
whether
> you might be German, though it is not germane.
>
> Hen
>