[AccessD] Function with Operators and Conditions

Charlotte Foust charlotte.foust at gmail.com
Tue Oct 5 15:37:33 CDT 2010


You can put the function in the expression cell (i.e., Expr1:
[MyDate]= FindMyDate(= Date variable) and then put True in the
criteria cell.

Charlotte Foust

On Tue, Oct 5, 2010 at 8:26 AM, Tony Septav <iggy at nanaimo.ark.com> wrote:
> Hey All
> Is it possible to embed an operator or condition in a function that is
> used as criteria in the query grid.
> I am sure I have solved this problem before, blame it on old age.
> What I want to do is change the criteria on the fly.
> Equal to   FndMyDate(=  Date variable)
> Less Than FndMyDate(<Date variable)
> Show all    FndMyDate(Like *)
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>




More information about the AccessD mailing list