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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Concatenate function from a Query, not a table 5
Make-table query with around 2 ml records taking too long 0
VBA - retrieve data on last create named range from previous inserted named range 0
Make Table Dynamic Table Name using INTO 2
Data Collection from Two tables 2
Access Print Files from Query Results 0
Insert a crosstab to temp table 4
perform INNER JOIN on query results 2

Back
Top