Creating Tables Dyamically

[Jennifer Sanders]

I want to use data from other tables to form a new table
dynamically. Data exists in other tables, but it's not
organized the way I need it to generate a chart. I would
like to create a new table that is always current and is
generated on the fly from several other tables. Can
Access do that and if so how?

 

[Jackie L]

How about a Make Table query? If there are additional fields needed that are not in the tables, you could add them the query just as a column with no value or add later with code


----- Jennifer Sanders wrote: ----

I want to use data from other tables to form a new table
dynamically. Data exists in other tables, but it's not
organized the way I need it to generate a chart. I would
like to create a new table that is always current and is
generated on the fly from several other tables. Can
Access do that and if so how

 

[Adrian Jansen]

Can you not write a query, joining the tables you want to extract the data ?
Then base the chart on that query. Then the chart will always have the
updated data, without having to update a table.

--
Regards,

Adrian Jansen
J & K MicroSystems
Microcomputer solutions for industrial control

 

[david epsom dot com dot au]

You can create a table with a create-table query,
or append data to an existing table with an append
query. Either way, simple queries, and the only
problem is getting rid of the old data. You need
another step: either a delete query to clear out
data, or vba KILL to delete a temporary database,
or DAO tabledefs.delete to drop a temporary table,
or.....

(david)