name table dynamically

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!
 
D

Douglas J. Steele

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.
 
Top