> I can set a specific criteria from a function but not a wildcard. For
> example:

> Function NameCriteria()
> NameCriteria = "Joe"
> End Function

> I then put NameCriteria() in the Name field of a query and I only get
> anyone with the name of "Joe", which is what I expect. But if I want to
> see everyone (by setting the criteria to *, or people  who have Joe in
> their name (NameCriteria = "Joe*" ),  it doesn't work. I've tried single
> quotes and other odd variations, but nothing seems to work.

> Any suggestions would be greatly appreciated.

> Thank you.

> -Rob G.

> Set the criteria line for the field in the query definition to

>     Like NameCriteria()

> That works for me.

> --

> Dirk Goldgar
> (remove NOSPAM from reply address)

> > I was wondering if there was a way to set a wildcard criteria from a
> > function.

> > I can set a specific criteria from a function but not a wildcard. For
> > example:

> > Function NameCriteria()
> > NameCriteria = "Joe"
> > End Function

> > I then put NameCriteria() in the Name field of a query and I only get
> > anyone with the name of "Joe", which is what I expect. But if I want to
> > see everyone (by setting the criteria to *, or people  who have Joe in
> > their name (NameCriteria = "Joe*" ),  it doesn't work. I've tried single
> > quotes and other odd variations, but nothing seems to work.

> > Any suggestions would be greatly appreciated.

> > Thank you.

> > -Rob G.