Updatable Union Query

G

Guest

Hi,

I see I can update a table from the output of a simple select query. However
this doesn't work with a union query.
Is there a way to make a union query updatable?

Thanks,
Kanga
 
A

Allen Browne

No. UNION queries are never updatable.

The best solution is probably going to be to redesign your tables into one,
adding an extra field to indicate whatever difference is intended by having
them in different tables.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Update Query including a Union Query 2
updatable query 2
query is not updatable;; urgent 1
Comlex union query question 4
Union Query and Field Alias 7
Run Make Table Query on Union Query 2
UNION QUERY 2
determining if a field should be included 6

Top