list of numbers stored as text in a table cell as the criteria for a query?

Tech-Archive recommends: Speed Up your PC by fixing your registry

I'm trying to insert a list of values from a table into the where
clause of a query. I have a several sets of values stored as text that
I'd like to use as criteria in a query on a different table, for
example,

TableA:
ID CoumnA
1 | "3", "5","17", "34"
2 | "1", "12","15"

Where clauses:

WHERE TableB.ColumnB IN( "3", "5","17", "34")
or,
WHERE TableB.ColumnB IN( "1", "12","15")



Is there an easy way to get those values from a single cell in a table
and into the query? I've tried a few things, DLookUp, for example, but
get no values returned.
I think there should be a quick way of doing this without resorting to
VBA, but I can't think what it is.

.

Relevant Pages

  • RE: Any good T-SQL quick reference recommended?
    ... The full syntax of the SELECT ... SELECT Clause ... Specifies the columns to be returned by the query. ... Specifies that duplicate rows can appear in the result set. ...
    (microsoft.public.sqlserver.programming)
  • RE: Xlocking with a select statement
    ... named query expression, order clause, update clause, lock option ... A result table or the underlying base tables are updateable if the query ... A lock can be requested for the ...
    (microsoft.public.sqlserver.programming)
  • Re: update query: still having problems
    ... "Michel Walsh" wrote: ... From the User Interface, in the toolbar, or the menu, when you edit a query, ... If this is what you want, fine, else, add a WHERE clause to limit ... SELECT Department.*, sheet1.* ...
    (microsoft.public.access.queries)
  • Re: update query: still having problems
    ... "Michel Walsh" wrote: ... you should find a button that allows you to change the query "type". ... If this is what you want, fine, else, add a WHERE clause to ... SELECT Department.*, sheet1.* ...
    (microsoft.public.access.queries)
  • Re: VB-ADO-SQL Server : SQL Server performs logins after some queries
    ... If you have some joins or WHERE clause in your statement, ... Also try to minimize selection of the records using WHERE ... Incase of actual action query, ... >> of queries and I've concluded that in case of an internet conection the ...
    (microsoft.public.vb.database.ado)