name table dynamically

  • Thread starter Thread starter shank
  • Start date Start date
S

shank

Is it possible to MAKE a table and issue a table name dynamically?

The following doesn't work, but you should get an idea what I want to do.

SELECT Data.Year, Data.Quarter INTO 'Year ' & Data.Year FROM Data;

thanks!
 
What you're trying to do is generally frowned upon. You should never store
data as part of table or field names. As well, you should never store data
redundantly.

Create a query and use the query rather than storing it in a table.
 
Back
Top