By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,503 Members | 2,821 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,503 IT Pros & Developers. It's quick & easy.

Create table from query?

P: n/a
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

Jan 2 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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 ***
Jan 2 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.