SQL for Quering Access Tables using a Table/Field List Table

[robboll]

I have a Table called TableField that has the table names, fields and
Data type of all the tables and fields in the database. They are set
up as follows:

Table: TableField

TableName FieldName Type
Table1 LName Text
Table1 FName Text
Table1 Address1 Text
Table1 Address2 Text
Table1 State Text
Table1 Zip Text
Table2 Color Text
Table2 Descrip Text
Table2 Size Text
Table2 Temp Text

 

[Ken Snell [MVP]]

see reply in other newsgroup where you also posted this question

 

[robboll]

Ken,

I tried your suggestion and it didn't work for me. This is why I took
it a step further. I've got the table with the table and field
columns, now I'm just trying to build a sql statement that gets its
values from that table and then populates a seperate Results table with
what it finds.