change data in a union query

  • Thread starter Thread starter Neil
  • Start date Start date
N

Neil

I need to have two seperate tables in access 97 (for dealing with
different types of purchase orders). The primary key isn't duplicated
between these tables and I view this data later on by using a union
query. Problem is I don't seem to be able to change / modify the data
when it is displayed from the union query. Is there any way around
this?

Cheers,
Neil
 
Yes, put it all in one table instead of two. Add a field called "type" or
something similar to differentiate between the two.
 
I need it in two seperate tables for reasons that are too long and
tedious to go into. Can anyone confirm that there's no way of doing as
update on a union query?
 
I need it in two seperate tables for reasons that are too long and
tedious to go into. Can anyone confirm that there's no way of doing as
update on a union query?
Click to expand...

You cannot update the result of a UNION.
 
Back
Top