[AccessD] IN clause function

Drew Wutka DWUTKA at marlow.com
Tue Sep 30 23:49:30 CDT 2003


Never mind....open mouth, insert foot...didn't work...grin

Drew

-----Original Message-----
From: Drew Wutka [mailto:DWUTKA at marlow.com]
Sent: Tuesday, September 30, 2003 11:32 PM
To: 'Access Developers discussion and problem solving'
Subject: RE: [AccessD] IN clause function


Ya, just do this:

Function GetInStr() as String
GetInStr="1,2,3,4"
End Function


That should work just fine....

Drew
-----Original Message-----
From: John Colby [mailto:jcolby at colbyconsulting.com]
Sent: Tuesday, September 30, 2003 8:17 AM
To: AccessD
Subject: [AccessD] IN clause function


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

_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
_______________________________________________
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