[AccessD] IN clause function

Gustav Brock gustav at cactus.dk
Tue Sep 30 08:23:35 CDT 2003


Hi John

There was a thread on this some long time ago.
The conclusion was no.

It would be a great feature though ...

/gustav


> Is it possible to return a comma delimited string using a function into the
> where of a saved query when the Where is an IN.  Boy does that read
> convoluted!

> IOW,

> IN ( GetInStr() )

> where the GetInStr() function returns a comma delimited list of items to use
> in the IN clause.

> I have never succeeded in getting something like this working, and as a
> result have had to build a query on-the-fly.

> John W. Colby
> www.colbyconsulting.com



More information about the AccessD mailing list