[AccessD] Extended Combobox Questions

Ryan W wrwehler at gmail.com
Sat Jul 3 10:33:07 CDT 2021


I can’t help with point 1 but I use Allen Browne’s concatrelated function often when I’m building a query with an IN() clause. 

http://allenbrowne.com/func-concat.html

Sent from my iPhone

> On Jul 3, 2021, at 10:24 AM, Arthur Fuller <fuller.artful at gmail.com> wrote:
> 
> 1,The combobox has two columns, the first being the PK of the row in the
> source row in the table, the second a text description. The user may
> select several items, or even all of them.  I refer to the selected items?
> 2. I want to concatenate the PKs selected for use in the In() clause of a
> SQL statement. Given that they are numeric, is it enough just to wrap them
> in STR() calls?
> 
> -- 
> Arthur
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com


More information about the AccessD mailing list