Alter record based on query result?

[Richard Williamson]

Hi all,
I have managed, using a quite tortuous route, to select certain
records in a UNION query. This is based on the results of other
queries.

Question: how the devil do I change the value of a field in these,
and only these, records? I have tried an update query and VBA all
without success. I know help says that you can't change the values in
a query if the data is from other queries or joined tables, but there
must be a simple way of doing what I want. Mustn't there?

Regards
Richard

[Bogdan Zamfir]

Hi,

I have managed, using a quite tortuous route, to select certain
records in a UNION query. This is based on the results of other
queries.

Question: how the devil do I change the value of a field in these,
and only these, records? I have tried an update query and VBA all
without success. I know help says that you can't change the values in
a query if the data is from other queries or joined tables, but there
must be a simple way of doing what I want. Mustn't there?
What are you trying to accomplish? The changes should be permanent, so saved
to original tables, or you just want them for some temporary work, like a
report, then you can get rid of them?

If you want just temporary changes, for example to use in a report, you can
create a make table query. Update data in resulting table, use it as you
need, then you can delete the table.

If you want to permanently save changes in your source tables, you might
need to find some key field or fields who unique identify your records in
source tables. Then, based on those key fields, create one or more
recordsets from your original tables, and update data you need on them

If you post more details, I might help you more specifically.

HTH
Bogdan

Regards
Richard

[MeadeR]

If there's unique ID's returned by the Union query you can create an
Update query
based on the result of the ID's for example:

Update tblSomeTable
Set Field1 = SomeValue
Where tblSomeTable.ID In (Select ID From UnionQuery)

Not sure if that helps - I think we need more specific for any
additional suggestions
ri*****************@ntlworld.com (Richard Williamson) wrote in message news:<62**************************@posting.google. com>...

Hi all,
I have managed, using a quite tortuous route, to select certain
records in a UNION query. This is based on the results of other
queries.

Question: how the devil do I change the value of a field in these,
and only these, records? I have tried an update query and VBA all
without success. I know help says that you can't change the values in
a query if the data is from other queries or joined tables, but there
must be a simple way of doing what I want. Mustn't there?

Regards
Richard

[Richard Williamson]

Woohoo! Taht's got it sorted. Note to self: must start doing more in
SQL rather than query design view!

Where would I be without you guys?!

Many thanks
Richard

Me****@ComputerSOSNJ.com (MeadeR) wrote in message news:<32**************************@posting.google. com>...

If there's unique ID's returned by the Union query you can create an
Update query
based on the result of the ID's for example:

Update tblSomeTable
Set Field1 = SomeValue
Where tblSomeTable.ID In (Select ID From UnionQuery)

Not sure if that helps - I think we need more specific for any
additional suggestions
ri*****************@ntlworld.com (Richard Williamson) wrote in message news:<62**************************@posting.google. com>...

Hi all,
I have managed, using a quite tortuous route, to select certain
records in a UNION query. This is based on the results of other
queries.

Question: how the devil do I change the value of a field in these,
and only these, records? I have tried an update query and VBA all
without success. I know help says that you can't change the values in
a query if the data is from other queries or joined tables, but there
must be a simple way of doing what I want. Mustn't there?

Regards
Richard