Table Function in Query

  • Thread starter Thread starter Pat Randall
  • Start date Start date
P

Pat Randall

Is it possible to have a table function in a query? For example,
"Select * from getTableName()". I want to use a function to return the
table name instead of hard coding the table name in the SQL statement.
 
Not in the QBE window. You can do this in VBA code and then you run the
query from code.
 
Back
Top