Create table from query?

Hi Group.

I would like to add some information to a query.
I tried to create a table with the information from the query but then
if i run the query again the additional data will be lost.

Below I'll try to illustrate what i mean:

Table A right join Table B -> Query C -> Create Table C -> Add values
to Table C

Any other way to do this?

\Philehof

re: Create table from query?

In Access a query of joined tables is not updatable. You can't add data
to a join query like you can to a one table query. In MS Sql Server you
can do something like this using an InsteadOf trigger. But in the
trigger you are telling it what table gets the data. Access doesn't
have this functionality (at this time). If you want to add data to a
join query you would have to write a routine where you run the query to
see the result set. Then, based on some condition of the result set you
insert your additional data to the respective table. This would sort of
be simulating the Sql Server InsteadOf trigger.

Rich

*** Sent via Developersdex http://www.developersdex.com ***