[AccessD] IN clause function

John Colby jcolby at colbyconsulting.com
Tue Sep 30 08:16:54 CDT 2003


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