If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Creating Tables Dyamically
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? |
#2
|
|||
|
|||
Creating Tables Dyamically
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? |
#3
|
|||
|
|||
Creating Tables Dyamically
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 "Jennifer Sanders" wrote in message ... 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? |
#4
|
|||
|
|||
Creating Tables Dyamically
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) "Jennifer Sanders" wrote in message ... 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? |
Thread Tools | |
Display Modes | |
|
|