expression as a value of a table

[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?

 

[Guest]

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.

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?

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
__________________________________________