name table dynamically

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

 

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