Pullling Table Name

[colmtourque]

How do you pull the tables name in a query?

 

[tjs206]

Are you trying to pull the table name as to use in a criteria expression?

 

[colmtourque]

I am wanting this

I have table1(field1, field2, field3)

I want to do
Select table1.field1, table1.field2, table1.table1name
From table1

It is for a Union Query that is going to feed another query but I need to be able to sort in that query based of off all things the table name.
What I have done for the time being is to use expressions
Select table1.field1, table1.field2, table1name AS Expr1 but for ease of use it would be better if I could use the actual table name.

Thanks