Update Query including a Union Query

[Guest]

Hello:
I want to create a update query. In this query I link a union query with a
table. If certain criteria match, then use the data in union query to update
the data in the table. However, I got error message and seems not updatable.
I could make a table first for the union query, but is there any other
efficient ways to solve it?
Thanks in advance!

 

[Guest]

hi,
using a temp table is a tried and true, acceptable method
of dealing with your problem.
just make sure your temp table remains empty when you are
not using it ie fill it with data, work the data and when
done, delete the contents of the temp table, not
neccessarily the tempt table itself.

 

[Guest]

Hello:
Thanks for you reply!
I am just wondering why it is not a good idea to delete the table.