[AccessD] query criteria

Thanks Stuart / John

    > Just put "LIKE GetEventCriteriaString()" in the criteria and replace 
the "IS NOT NULL" in
    > your function  with "*"

When I put LIKE GetEventCriteriaString()  (with no quotation marks at all) 
as the criteria it works.

Thanks - I would not have thought of that.

Kath

----- Original Message ----- 
From: "Stuart McLachlan" <stuart at lexacorp.com.pg>
To: "Access Developers discussion and problem solving" 
<accessd at databaseadvisors.com>
Sent: Wednesday, May 21, 2008 4:22 PM
Subject: Re: [AccessD] query criteria


>I see - you've actually putting the function name in the QBE grid.
>
> Take a look at the query in SQL view and you will see what is actually 
> happening.
>
> Access converts it into:
> ... WHERE (((myTable.myField) = GetEventCriteriaString()));
>
> Just put "LIKE GetEventCriteruaString()" in the criteria and replace the 
> "IS NOT NULL" in
> your function  with "*"
>
>
>
>