Union Query - Modifying

[Matt_Fairfield]

Is it possiable to modify the data inside a union query.
This is what i have done!
I have Joined 6 common fields from 30 different tables using a UNION query
and i want to update one of the columns!
Is this possiable?
Mine wont let me!
Maybe i am missing some code

 

[Duane Hookom]

Union queries (at least in Access) are not updateable.

 

[Brendan Reynolds]

No. You could turn the union query into a make table query (or design a
table with the necessary fields, and then turn the union query into an
append table). Once you have the data into the new table, then you'll be
able to update it. Obviously, this will still leave you with a problem if
you need to get the changes back into the original 30 tables - but perhaps
you may not need to do that?

--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com

The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.

 

[Matt_Fairfield]

Hey Duane
Thats what i figured i was hoping there was a way around it.
Thanks for your help
later

 

[Confused87]

Hi Brendan - this is what I am attempting at the moment:

I have Table A which is a mailing list and Table B which has loads more
information as well as addresses. I have made Query A from Table A; Query B
from Table B and Union Query 1 which collates them both.

I now change the information in Table A. Query A Updates but Union Query 1
doesn't. I have now made a table called Mailing List Total and I want to have
the info from Table A and Table B(or the Queries) upate into it. After that I
will be running a Report from it to create lables - how do I turn the Union
Query into an Append Query?

Many Thanks
C