I don't believe you can through a Union query. My question is why you have
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/14058-union-query.html
two tables? Why not just add a "location" field to the records and put them
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=14058
all in one table? That would be much more normalized.
If you do so, the data will be easier to work with and your queries would be
updatable.
You can still limit access to the data by location using the new location
field and filtering the data appropriately.
Most of the time (but NOT always) when you find yourself using Union
queries, you are likely to have a normalization issue.
--
Rick B
"Secret Squirrel"
wrote in
message news:918C9E8D-C8E4-4E2F-9EB0-AAC971934B75@microsoft.com...
>I have a union query that is pulling data from 2 tables. The fields are the
> same in each table but they are different locations. There is one field
> that
> I am pulling that is a "Yes/No" field. When I open my form that runs the
> query I want to be able to put a check in that "Yes/No" field. When I try
> it
> I get a message that says the record is not updateable. Any idea if this
> can
> be done through a union query or am I missing something?