expression as a value of a table

T

thread

Hi all,
I have a table that contains numbers and names of tables all in one
field,
the type of the records for the table is text.
is it posible to request to convert the value to a value of a table as
part of SQL sentence?
 
T

Tom Wickerath

Possibly, but since your question is rather unclear, I think you will need to
supply some more details.
I have a table that contains numbers and names of tables all in one
field, the type of the records for the table is text.
Click to expand...

Like this? (If not, then please provide an example):

tblTables
TableNames (Text)

TableNames (sample data)
1. Customers
2. Orders
3. Order Details
4. Employees
5. Suppliers
6. Categories
7. ShipVia
is it posible to request to convert the value to a value of a table as
part of SQL sentence?
Click to expand...

So, if for example, you had this data displayed in a listbox on a form, and
the fourth item was selected, you would want to create a SQL statement like
this?

SELECT * FROM Employees;

If not, then what are you looking for?


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________
 
Top