[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